function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

organbylady - 11 Mar 2008 16:22 GMT

In a worksheet, I have a list cell(A1) that contains the words "Bodily
Injury", "Property Damage", and "Other". In the next cell(A2), I would need
a function that says: if A1 contaisn the word "bodily Injury" then go to
"Bodily Injury list" (which is on another worksheet). But if A1 contains the
word "Property Damage" then go to "Property Damage list". but if A1 contains
the "Other" then go to "Other list".

Hopefully you can help

Thank You

Reply to this Message

Bernie Deitrick - 11 Mar 2008 17:10 GMT

Visit here:

http://www.contextures.com/xlDataVal02.html

for a technique to do what you (apparently) want.

HTH,
Bernie
MS Excel MVP

> In a worksheet, I have a list cell(A1) that contains the words "Bodily
> Injury", "Property Damage", and "Other". In the next cell(A2), I would need
[quoted text clipped - 6 lines]
>
> Thank You

Reply to this Message

organbylady - 11 Mar 2008 19:51 GMT

Thank You. This is just what I was looking for!!!!

> Visit here:
>
[quoted text clipped - 16 lines]
> >
> > Thank You

Reply to this Message