In column A, I have a list of employee numbers. In column B I have their
first name, and in column C their last name. What I want to do is to enter
an employee number in a cell, and for that cell to return their first and
second name. How can I do this please?

---
David Scott
Hampshire, England