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.

data matchin
 

Hi,
where do you want the results in table 1, I am assuming that you enter the
number you want to bring the information in A1 in sheet 1, in b1 you want to
pull the data from sheet2
=sumproduct(--(A1=Sheet2!$C$1:$C$50),sheet2!$B$1:$B$50)

if this helps please click yes, thanks

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