Related:
- Hyperlink and vlookup
- Insert hyperlink excel - Guide
- Remove hyperlink in word - Guide
- Hyperlink in email body gmail - Guide
- Vlookup if cell contains a word within text ✓ - Word Forum
- Transfer data from one excel worksheet to another automatically vlookup - 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)