Raymond has attended:
Excel Intermediate course
Excel Advanced course
Vlookups
vlookups from different workbooks
RE: vlookups
Hello Raymond
Thank you for your question and welcome to the forum.
Please find attached an example of a vlookup formula that refers to a table that is on a separate sheet (the sheet labelled Lookup). The cell with the Vlookup formula in it is highlighted in yellow. By typing an employee code into cell A3 (next to the lookup formula), the corresponding employee name should display from the table on the Lookup sheet.
I hope this helps.
Amanda