Report

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

Ask a question gbssraju 1Posts Thursday March 14, 2013Registration date March 14, 2013 Last seen - Last answered on Mar 14, 2013 at 04:39 PM by Zohaib R
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,
Helpful
+6
plus moins
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.
Was this answer helpful?  

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!