vlookup usage

[mollygillum]

Can you use Vlookup only in one excel document with multiple worksheets or can you reference another separate worksheet using VLookup?

[#2]

@mollygillum 

The lookup range (the second argument of VLOOKUP) can be on another worksheet in the same workbook, or even on a worksheet in another workbook. The best way to do this:

• Open both workbooks in Excel.
• Start the formula in the workbook where you want it, for example =VLOOKUP(A2,
• While still in formula edit mode, use the mouse or the keyboard to switch to the other workbook and to the relevant worksheet in that workbook.
• Select or point to the lookup range.
• Finish the formula the normal way by specifying the column index and TRUE/FALSE depending on whether you want an approximate or exact lookup.
• After confirming the formula (and filling it down if required, for example), switch to the workbook with the lookup range and close it (saving it if you modified it).
• Then save the workbook with the formula.

[#3]

Thank you so much
do you know if this can be done with one spreadsheet in sharepoint while the other receides locally?

[#4]

@mollygillum 

You'll have to try that - I think it might cause problems but I have no experience with that.