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 » VLookup
Resolved · Medium Priority · Version 2003
Lucy has attended:
Excel Advanced course
Can I use different different worksheets and spreadsheets while using this function.
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 2010Did you know that the old CTRL key shortcuts haven't changed from previous versions of Excel to the 2010 version? |
We'll call during UK business hours
Server loaded in 0.09 secs.