vlookup

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 » VLookup

VLookup

resolvedResolved · Medium Priority · Version 2003

Lucy has attended:
Excel Advanced course

VLookup

Can I use different different worksheets and spreadsheets while using this function.

RE: VLookup

Hello Lucy

Thank you for your question and welcome to the forum.

The VLOOKUP function will work ok between different sheets in the same file, but not between two different files. If you wanted to use data that was stored in a different file, then you would need to link it through to the spreadsheet where you were using the VLOOKUP function first, before setting up the VLOOKUP.

If you are creating VLOOKUP functions that work between different sheets in the same file, then it is useful to create a name for the table array you are using in the function before entering it into the spreadsheet.

Amanda


 

Excel tip:

Some examples of CTRL key shortcuts in Excel 2010

Did you know that the old CTRL key shortcuts haven't changed from previous versions of Excel to the 2010 version?

They remain exactly the same:

Ctrl+B for bold
Ctrl+I for italics
Ctrl+P to Print
Ctrl+S to Save

View all Excel hints and tips


Server loaded in 0.09 secs.