Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Vlookups
Resolved · High Priority · Version 2003
Raymond has attended:
Excel Intermediate course
Excel Advanced course
vlookups from different workbooks
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
Thu 27 Nov 2008: Automatically marked as resolved.
|
Excel tip:Percentage formatCtrl+Shift+% applies the Percentage format, with no decimal places. |
We'll call during UK business hours
Server loaded in 0.07 secs.