ok i have a long list of id numbers (including duplicates). They are employee ID numbers. i have taken the list, copied it to a new worksheet, removed the duplicates and attached the corresponding job titles beside this list. What would be the best way to apply the job titles to the longer list? could i do this in a cell formula or would this take a case statement or IF statement in VBA?
Bookmarks