function

[organbylady]

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

 

[Bernie Deitrick]

Visit here:

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

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

HTH,
Bernie
MS Excel MVP

 

[organbylady]

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