Compare 2 uneven colums
 

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!

Compare 2 uneven colums
 

Put in B1:
=IF(ISNA(MATCH(A1,C:C,0)),"",INDEX(D: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" wrote:
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.

Compare 2 uneven colums
 

Perfect!! Thank you!!

"Max" wrote:

Put in B1:
=IF(ISNA(MATCH(A1,C:C,0)),"",INDEX(D: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" wrote:
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.