Hi Guys,
This is the simple formula for my vlookup.
"VLOOKUP(C2,DF6020.xls!$C:$I,7,0)"
DF6020 is also the contents of cell A2.
Can I do something like, "VLOOKUP(C2,"A2".xls!$C:$I,7,0)". This obviously doesn't work.
So eventually I can pick the file name from cell A2 and put the .xls extention after it and do a vlookup into that file?
I hope I'm clear.
Thanks
Rizo
You would need to use INDIRECT
=VLOOKUP(C2,INDIRECT("'["&$A$2&".xls]SheetName'!C:I"),7,0)
NOTE that XL's in built INDIRECT function will only work if the target file (ie A2) is open... else you will need to use INDIRECT.EXT as offered within the 3rd party morefunc.xll add-in
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
I have already tried this but it doesn't work.
Gives me #ref error.
Also the whole point was to get data while the file was closed.
Then as stipulated use INDIRECT.EXT (ie install morefunc.xll)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks