Compare two columns in different sheet and retrive corrspo value

[Closed]
Report
Posts
1
Registration date
Thursday March 14, 2013
Status
Member
Last seen
March 14, 2013
-
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
-
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

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
46
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month