Check 2 fields from one table and match with 2 fields of other table

[VaibhavAr]

Hi,

I want to get data from one table to other by matching 2 separate fields from 2 tables placed in different sheets of the excel file.

Eg.:

Sheet 1 Data

Header 1 Header 2 Result 1
abc x
abc y
abc z
def x
ghi y


Sheet 2 Data

Header 1 Header 2 Quantity 1
abc x 3
abc y 5
abc z 2
def x 4
ghi y 7


Now I want to compare header 1 & header 2 of both the sheets and get the quantity1 data from sheet 2 to result1 field in sheet 1.

Please help.

[sktneer]

Try this...

On Sheet1
In C2

Please Login or Register  to view this content.

and copy it down. Change the range reference as required but don't refer the whole column reference like A:A etc.

Sheet1:
Sheet1.JPG

Sheet2:
Sheet2.JPG

[sktneer]

Thanks for the rep.

If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.