Try this:

E2 = Jungleboy, book_ball_12k

=LOOKUP(1E100,SEARCH(A$2:A$3,E2),B$2:B$3)

--
Biff
Microsoft Excel MVP


"Yossy" wrote in message
...
I have the following data
Cell A Cell B
book_ball_12k Exercise
ham_pie_l89 Food

How do I do a v-lookup on this value - Jungleboy, book_ball_12k from
above and get Exercise. I want the look up to look at book_ball_12k
from
the value (Jungleboy, book_ball_12k) - probably use the comma to denote
where
to get value from and pick Exercise.

All help totally appreciated..

Thanks