| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Which numbers give desired result | Excel Discussion (Misc queries) | |||
| vlookup does not give the result in the cell even though it is | Excel Worksheet Functions | |||
| Trying to find Matches and Give a Result | Excel Worksheet Functions | |||
| How do I get a cell to give a result based on the month we are in? | Excel Worksheet Functions | |||
| entering a26-02 into a cell give strange result | Excel Discussion (Misc queries) | |||
Linear Mode
