v-Lookup between values and give result -Help
 

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

v-Lookup between values and give result -Help
 

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

v-Lookup between values and give result -Help
 

Hi,

Lets suppose the string (Jungleboy, book_ball_12k)
including the parenthesis is in F1, try this

=VLOOKUP(SUBSTITUTE(TRIM(MID(F1,SEARCH(",",F1)+1,L EN(F1))),")",""),A1:B20,2,FALSE)

Mike

"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

v-Lookup between values and give result -Help
 

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

v-Lookup between values and give result -Help
 

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

--
Biff
Microsoft Excel MVP


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