vlookups

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Vlookups

Vlookups

resolvedResolved · High Priority · Version 2003

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

Attached files...

vlookups across sheets.xls

Thu 27 Nov 2008: Automatically marked as resolved.


 

Excel tip:

Percentage format

Ctrl+Shift+% applies the Percentage format, with no decimal places.

View all Excel hints and tips


Server loaded in 0.07 secs.