Forum Discussion
vlookup usage
Can you use Vlookup only in one excel document with multiple worksheets or can you reference another separate worksheet using VLookup?
3 Replies
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.
- Thank you so much
do you know if this can be done with one spreadsheet in sharepoint while the other receides locally?You'll have to try that - I think it might cause problems but I have no experience with that.
