Compare data and copy

Hi Guys,  

Hopefully this will be easy for someone slightly more Excel bright than me?

I have 2 sheets..  Sheet1 has a column of ID numbers which I want to compare to a column of the same ID numbers on sheet 2 and for each unmber on sheet 1 copy the name associated with the sheet 2 ID back to a cell next to the sheet 1 ID number.

Thanks a lot in advance

By: Steven

Leave a Reply

Your email address will not be published. Required fields are marked *