function
 

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

function
 

Visit he

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

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

HTH,
Bernie
MS Excel MVP


"organbylady" wrote in message
...
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

function
 

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


"Bernie Deitrick" wrote:

Visit he

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

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

HTH,
Bernie
MS Excel MVP


"organbylady" wrote in message
...
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