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. |
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. |
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. |
All times are GMT +1. The time now is 06:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com