Niek,

Help!

(See my original "matching cells" posting dated June 17).

I've changed my spreadsheet:

Column A (formerly containing 60,000 cells)
is now Column B (containing 59,414 cells)

and Column B
is now Column I.

Accordingly, I've changed your formula to:

=IF(VLOOKUP(B1,$I$1:$I$59414,1)=B1,B1,"")

But now, the data in Column I is NOT being moved down to the matching
cells in Column B.

What am I doing wrong?

Thanks,

Gary