v-Lookup between values and give result -Help

[Yossy]

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

 

[JE McGimpsey]

One way:

Assume 'Jungleboy, book_ball_12k' in cell J1.

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

 

[T. Valko]

Try this:

E2 = Jungleboy, book_ball_12k

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

 

[T. Valko]

Note that with that formula there can't be any empty cells in the first
column of your lookup table.