Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

VLookup

Resolved · Medium Priority · Version 2003

Reply Wed 6 Aug 2008, 16:56Delegate Lucy said...

Lucy has attended:
Excel Advanced course

VLookup

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

For upcoming training course dates see: Pricing & availability

Reply Fri 15 Aug 2008, 13:26Trainer Amanda said...

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 articles

· Creating Error Alerts In Excel Using Data Validation
· The Best Way To Use Clip Art Images In Excel
· How To Identify The Most Critical Data In A Large Excel Spreadsheet
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· How To Create A Macro In Excel 2010

Please browse our web site to find out more about
training+excel+microsoft and other Microsoft training courses.

Excel tip:

Make macros work in newer versions of Excel

If you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using.

To do this, go to Tools - Options - Security.

Select Macro Security and change the security setting to Low.

Tick the boxes next to 'Trust Add-ins' and 'Trust Visual Basic' and click OK.

After you have restarted Windows, you should then be able to use your macros created in earlier versions of Excel.

View all Excel hints and tips