Thanks Guys! Really useful.

--
---
David Scott
Hampshire, England
"Dave" wrote in message
...
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