Formula to compare columns
Maybe one way:
=INDEX(A$1:D$3,MATCH(A3,C$1:C$3,0),4)
Adjust your ranges as needed.
Regards,
Paul
--
"EDF2017" wrote in message
...
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!
|