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
Bookmarks