Related:
- Hyperlink and vlookup
- How to hyperlink in gmail - Guide
- How to remove hyperlink in word - Guide
- Excel hyperlink to another sheet - Guide
- Remove underline from hyperlink css - Guide
- How to hyperlink image in gmail signature - 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)