Related:
- Hyperlink and vlookup
- How to copy from wikipedia without hyperlinks - How-To - Office Software
- How to find all hyperlinks in a word document - Guide
- Convert ppt to pdf with hyperlinks - Guide
- Transfer data from one excel worksheet to another automatically vlookup - Guide
- Can you hyperlink a pdf in excel - Guide
1 reply
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)
