Hi. I need a function to do this for me.
If I enter a number in Cell A1, say 129, I want cell B1 to Display the name that corresponds to that employee number. So if A1 is 129, I need B1 to Display Jon Smith. If A2 is 130, then B2 should display Joanna Smith. Etc, etc.
Can anyone provide an easy solution to this for me?
Thanks
Bookmarks