One way:

Assume 'Jungleboy, book_ball_12k' in cell J1.

=VLOOKUP(MID(J1,FIND(",",J1)+1,255),A:B,2,FALSE)


In article ,
Yossy wrote:

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