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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
vlookups

ResolvedVersion 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:

Adjusting the Elevation and Rotation in a 3-D Chart

For any 3-D chart you create, you can adjust the chart

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.