Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
data matchin
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 name locatn position 4 6 8 james atl 3 3 2 1 ben oh 7 5 7 9 tony Hx 8 if i want 3 under column A in table 1 to match 3 under colum position table 2 and bring back atl under locatn. as such that 7 in table one can bring back Hx as location or any other horizontal correspondence. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Help with Lookup Formula that Also Puts in Text Where Matchin | Excel Worksheet Functions | |||
Increase Your Business By Data Conversion, Data Format and Data EntryServices in India | Excel Worksheet Functions | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
sumif function with partially matchin sentences | Excel Discussion (Misc queries) | |||
create reference formula that looks through all sheets for matchin | Excel Worksheet Functions |