Vlook match

[kay]

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.

 

[Jacob Skaria]

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

 

[kay]

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