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