Forum Discussion
Need to update
Hi all, I need some guidance on how or if I can do what I'm hoping to do. I have created a Excel spreadsheet with a list of employee names, department, and tenure ranking then I added separates w...
You need to look into LOOKUP(), VLOOKUP(), XLOOKUP() type of functions. Ideally you should use Employee ID instead of name since you may have more than 1 Mary Smith and it is easy to make spelling errors like MaryAnne vs MaryAnn or Chris vs Christy etc.. But basically you use the Employee ID on the shipping dept worksheet to 'lookup' the corresponding information on the main page. I hope that helps.