I have two workbooks, workbook one contains a list of employee numbers,
firstname, lastname. Workbook two contains the employee number. I would like
to index workbook one, matching on the emp number and concatenate firstname
lastname into a single cell. Is that possible with a formula or do I need a
macro?

Thanks in advance!