need help with formula to compare columns and add vaule for matches

[cavsfan]

I need to compare values in column A to all values in column B and when a match is found enter the corresponding data in column C (same row) into column D. There are 8741 rows in column a, 2708 in column B & C. 0 in column D currently. Please help





A1 B1 C1 D1

x y orange blue

y x blue orange

z z red red

[FDibbins]

Hi and welcome to the forum

Based on your sample data, try this, copied down...
=INDEX(C:C,MATCH(A1,B:B,0))

[cavsfan]

thanks for the welcome.... I am a beginner with excel.

I attempted to copy the formula =INDEX(C:C,MATCH(A1,B:B,0)) into D2 and hit enter and nothing happens, just see formula in D2. I copy it down and again just see the formula???

[cavsfan]

my headers are in A1:D1

data starts in A2

[cavsfan]

sample.xlsx


Here is a basic example of what I am trying to accomplish

[FDibbins]

I put this in E2, copied down, but if you need it in D2, then put it there instead...
=INDEX(C:C,MATCH(A2,B:B,0))

[cavsfan]

hmmm.

I tried copy into D2 and got #N/A error?

[FDibbins]

see attached

[cavsfan]

actual.xlsx

Would you please apply that formula to this file?? I am still having issues getting this to work. Thanks!!!!!!

[cavsfan]

looking to have =INDEX(C:C,MATCH(A2,B:B,0)) applied to attached file "actual.xlxs" not sure why I cant get this to work in D2

[FDibbins]

Its giving NA because you have no matches

[cavsfan]

I did a find on value in column B3 and have a match (A82) so that should copy C3 to D3 in same row?

[FDibbins]

They are not the same. A82 and a few trailing spaces at the end. To allow for that, change the formla to this...

=MATCH(TRIM(A2),$B$2:$B$2708,0)