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?
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?
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.