Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlook match
hi expert,
how can i use vlook in looking up a similar or equal number of a "look up value" from another table of array and returning the corresponding horizontal value ? like table 1 tablle 2 A b c positon name locatn 4 6 8 3 james atl 3 2 1 7 ben oh 5 7 9 8 tony Hx if i want 3 under column A in table 1 to match 3 under colum position table 2 and bring back atl under locatn. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlook match
Assuming you have table 1 in Sheet1 and table 2 in Sheet2; try the below..
=VLOOKUP(A2,Sheet2!A2:C100,3,FALSE) If this post helps click Yes --------------- Jacob Skaria "kay" wrote: hi expert, how can i use vlook in looking up a similar or equal number of a "look up value" from another table of array and returning the corresponding horizontal value ? like table 1 tablle 2 A b c positon name locatn 4 6 8 3 james atl 3 2 1 7 ben oh 5 7 9 8 tony Hx if i want 3 under column A in table 1 to match 3 under colum position table 2 and bring back atl under locatn. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlook match
thanks but no it did not help as i didntget the result.
table 1 tablle 2 A b c positon name locatn 4 6 8 james 3 atl 3 2 1 7 ben oh 5 7 9 8 tony Hx assumin the table was like this and i wanted to find a match for 3 from table 1 in table 2 to give me the coresponding value of 3 in table 2 under location which is atl, as such thatif i find the corresponding location of 7 in table 2 ie oh. ie find a value equal to the lookup value in table 2 and find a corresponding value of another column?many thanks "Jacob Skaria" wrote: Assuming you have table 1 in Sheet1 and table 2 in Sheet2; try the below.. =VLOOKUP(A2,Sheet2!A2:C100,3,FALSE) If this post helps click Yes --------------- Jacob Skaria "kay" wrote: hi expert, how can i use vlook in looking up a similar or equal number of a "look up value" from another table of array and returning the corresponding horizontal value ? like table 1 tablle 2 A b c positon name locatn 4 6 8 3 james atl 3 2 1 7 ben oh 5 7 9 8 tony Hx if i want 3 under column A in table 1 to match 3 under colum position table 2 and bring back atl under locatn. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
SSN format to match for vlook up | Excel Discussion (Misc queries) | |||
vlook/match/index | Excel Discussion (Misc queries) | |||
Vlook up or index match | Excel Worksheet Functions |