i have 2 seperate spreadsheets. i need to know if the codes on one exist on
the other, and if i do find a match, can i automatically populate fields such
as project manager, location etc.

also, how do i delete cells which are a repeat of previous cells?