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