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?
This sounds very straight forward. I would opt for using a look up formula. Built-in functions are always faster (mostly) than tacking on VBA to loop through cells.
You didn't provide any details about the sheet structure, but if you put the job titles to the left of the ID numbers you can use VLOOKUP and quickly fill the formula down the column by double-clicking the fill-handle of the cell pointer. So, if column-A holds the ID, place the look up formula in column-B and double-click the fill handle and Excel will automatically fill down as many rows as there are in column-A that contain values.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks