Related:
- Hyperlink and vlookup
- Remove hyperlink in word - Guide
- Hyperlink in gmail - Guide
- Transfer data from one excel worksheet to another automatically vlookup - Guide
- Hyperlink in excel - Guide
- How to find hyperlink in word - Guide
1 response
You can do vlookup from a closesd workbook without opening that workbook There are many solutions if you google search ("vlookup excel from closed workbooks")
an eample
suppose referece data is in Book1.xls which is saved in folder "desktop"
the new file is book2
if you type this formla
=VLOOKUP(A3,'C:\Documents and Settings\Administrator\Desktop\[Book1.xls]Sheet1'!A1:B100,2,FALSE)
you will get an answer without opening the book1.cls . note single quote and exclamation mark.
easier way in book1.xls ;name the raference range for e.g "data
then
=VLOOKUP(A3,'C:\Documents and Settings\Administrator\Desktop\[Book1.xls]'!data,2,FALSE)
an eample
suppose referece data is in Book1.xls which is saved in folder "desktop"
the new file is book2
if you type this formla
=VLOOKUP(A3,'C:\Documents and Settings\Administrator\Desktop\[Book1.xls]Sheet1'!A1:B100,2,FALSE)
you will get an answer without opening the book1.cls . note single quote and exclamation mark.
easier way in book1.xls ;name the raference range for e.g "data
then
=VLOOKUP(A3,'C:\Documents and Settings\Administrator\Desktop\[Book1.xls]'!data,2,FALSE)