Vlookup Formula use sheet name from cell A1
hello
i m using Vlookup formula in this way :
in above formula 13.4.14 is sheet name,,,,,,,,,and i give a name to sheets with date......e.g 13.4.14, 14.4.14, 15.4.14
Please Login or Register to view this content.
i want if A1.value=14.4.14 then sheet name should be 14.4.14
i don't want to change sheet name evrytimePlease Login or Register to view this content.
plz help
thanx
You are wanting to use Indirect as that works BUT you cannot use Indirect to another closed workbook, so have a look at this PULL function.
http://numbermonger.com/2012/02/11/e...sed-workbooks/
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Maybe:
Please Login or Register to view this content.
Ah I was on my phone and missed that this was for VBA. The above should work fine.
Hope it works for you. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks