Compare two columns in different sheet and retrive corrspo value [Closed]

gbssraju 1 Posts Thursday March 14, 2013Registration date March 14, 2013 Last seen - Mar 14, 2013 at 05:37 AM - Latest reply: Zohaib R 2421 Posts Sunday September 23, 2012Registration date July 16, 2018 Last seen
- 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,
See more 

1 reply

Best answer
Zohaib R 2421 Posts Sunday September 23, 2012Registration date July 16, 2018 Last seen - Mar 14, 2013 at 04:39 PM
8
Thank you
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.

Thank you, Zohaib R 8

Something to say? Add comment

CCM has helped 1662 users this month