Compare 2 uneven colums

[MDI Anne]

I have 3 data columns. Column A has 100 data cells, Column C has 25 data
cells, Column D has 25 data columns (related to column C).

I would like to compare Column A to C and if there is a match, put Column D
value in Column B, otherwise leave it blank.

Any help would be great!

Thanks!

 

[Max]

Put in B1:
=IF(ISNA(MATCH(A1,C:C,0)),"",INDEX(D,MATCH(A1,C:C,0)))
Copy down to the last row of data in col A
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik

 

[MDI Anne]

Perfect!! Thank you!!

Put in B1:
=IF(ISNA(MATCH(A1,C:C,0)),"",INDEX(D,MATCH(A1,C:C,0)))
Copy down to the last row of data in col A
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik