Thread: Find matching cell in other sheet and copy cell from different column

Hi,

Sorry I'm relatively new to this. I can write basic code but this is beoynd me. I think it might need a vlookup function but I'm not sure. I tried searching the forum but couldn't find anything close enough that I could modify. Maybe I'm not searching the right keywords?

Anyway...
I have two sheets (OLD and NEW) from a database of items we buy from our suppliers.
After a recent software update the Stage Numbers (used to break up a job budget) got a bit muddled. The reason I can't do a straight copy and paste of the column is that there are new items inserted all through the sheet.
A unique id for each item is in column B ("Item Number"), the Stage Numbers are in column AN.

I need to be able to do the following:-
For every row
- find the corresponding item number in the OLD sheet.
- copy the Stage Number from column AN to column AN in the NEW sheet.

I have uploaded a very short version of the file. The actual list is over 50,000 items. In the file I have uploaded all the Stage Numbers happen to be 3.5 in OLD and 3.3 in NEW, but stored as text. Not sure if this is relevant.

Thanks in advance.