Compare two columns in different sheet and retrive corrspo value

Closed
gbssraju Posts 1 Registration date Thursday March 14, 2013 Status Member Last seen March 14, 2013 - Mar 14, 2013 at 05:37 AM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Mar 14, 2013 at 04:39 PM
Hello,

How to compare two columns in one sheet with that of two columns in other sheet and retrive the corresponding Key value of the third column of the second sheet.
.
SHEET 1
A B C
1 W O
2 X P
3 Y Q
4 Z R


Sheet 2
A B C
1 Z R 10
2 X P 15
3 W O 20
4 Y Q 25

In the above example for Column C of Sheet 1 I want a formula where the corresponding calues of Column A & B in sheet 1 should match with that of sheet 2 and bring corresponding Value in Column C.

W & O of sheet one should bring value 20, the formula should search W and O then bring vlaue 20 under C1.

Regards,

1 reply

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 67
Mar 14, 2013 at 04:39 PM
Hi gbssraju,

Please use following formulas in Cells C1 through C4 of the Sheet 1:

=VLOOKUP(A1,Sheet2!$A$1:$C$4,3,0)
=VLOOKUP(A2,Sheet2!$A$1:$C$4,3,0)
=VLOOKUP(A3,Sheet2!$A$1:$C$4,3,0)
=VLOOKUP(A4,Sheet2!$A$1:$C$4,3,0)

Do reply with results.
8