Formula to compare columns

[EDF2017]

Hi,

Here is the challenge I'm having:

A B C D
1 6 500
3 5 200
5 4 100

I need to see if the value in cell A1 (etc.) appears in column C and if it
does then I want to return the value from column D in column B. So in this
case cell A3 matches C2 so I need the value in cell D2 to appear in cell B3.
Hopefully this makes sense and somebody will be able to help. Thanks in
advance!

 

[Dennis]

Put this in cell B1 and then copy down (change your range accordingly)
=IF(ISNA(VLOOKUP(A1,$C$1:$D$3,2,FALSE)),"",VLOOKUP(A1,$C$1:$D$3,2,FALSE))

 

[M Kan]

Assuming you have unique values in both A and C, I think the formula would
look like this:

=If(ISERROR(VLOOKUP(A1,C,2,FALSE)),"",VLOOKUP(A1,C,2,FALSE))

This would return the corresponding value from D where there is a match and
a blank if there is no match

 

[PCLIVE]

Maybe one way:

=INDEX(A$1$3,MATCH(A3,C$1:C$3,0),4)

Adjust your ranges as needed.

Regards,
Paul