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