Is there way In excel I can type a name in cell A1 and have it find the employee ID number from a List and post it in Cell B1.
Example:
Type there name into A1. Then B1 will look at the list in Q50:Q75 then find the employee Number in R50:R75 and post it into cell B1
Type there name into A2...