Related:
- Hyperlink and vlookup
- Hyperlink in gmail - Guide
- Remove hyperlink in word - Guide
- Find hyperlink in word - Guide
- Hyperlink in excel - Guide
- Remove underline from hyperlink css - 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)