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. Then B2 will look at the list in Q50:Q75 then find the employee Number in R50:R75 and post it into cell B2
...A1...............B1
Tom Sebby .... 21
Kim Bowmen... 45
Joan Cruzr.......62
Matt Huklin..... 24
Mike Adin.........64
Q50.................R50
Tom Sebby .... 21
Sandy Miller.....18
Kim Bowmen... 45
Joan Cruzr.......62
Matt Huklin..... 24
Mike Adin.........64
Pam Bowmen....72
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. Then B2 will look at the list in Q50:Q75 then find the employee Number in R50:R75 and post it into cell B2
...A1...............B1
Tom Sebby .... 21
Kim Bowmen... 45
Joan Cruzr.......62
Matt Huklin..... 24
Mike Adin.........64
Q50.................R50
Tom Sebby .... 21
Sandy Miller.....18
Kim Bowmen... 45
Joan Cruzr.......62
Matt Huklin..... 24
Mike Adin.........64
Pam Bowmen....72