Hi everyone...
Excel 2003 for this...
I have a list of different ID's in column A of sheet 1 and I want to find them in column C of sheet 2 - if it's found I then want to return the value in the same row, but column AN (sheet 2) - if it's not found to write "CHECK".
The first ID in sheet one is in cell A2.
Could anyone offer any assistance please? Thanks very much.
Bookmarks