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. |
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 |