Hi,
I have two workbook, test1 (master file) and the other one is test_10_05_2014 with 100 some of them being updated daily. The last portion of the file "test_10_05_2014" is the date and we have different file on daily basis.
using Indirect function in vlookup should give corresponding value for the particular name. Formula used is giving error,
[VLOOKUP(A2,Indirect(" ' "&E1&" ' !$A$2:$X$1000),6,FALSE)]
please help.
Your look up formula starts with a capital letter, but your sheet names don't. This might be the issue. Also check that the spaces between the inverted commas are not causing a mis-match.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
You need to look at the format for referencing another workbook/ sheet in a formula. You seem to be missing square brackets, file extension, etc. Check what you end up with in cell E1.
="Test_"&TEXT(D1,"dd\_mm\_yy")&"Sheet1!" >>>> Test_11_05_14Sheet1!
I think the workbook might also need to be open for VLOOKUP to work but not 100% sure. Just saying in case it looks like the format is OK but you get an error (possibly a different one). References to closed workbooks would require the full path, as opposed to just the workbook name.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks