You can use indirect() to turn a string into a reference (e.g. =VLOOKUP("25NN2",indirect(W56),3,FALSE)), but if you use it a lot Excel will grind to a halt (even with a really good computer) as it is a very memory-intensive function.
More often than not you can use more efficient functions in place of indirect.
hth
Last edited by Cheeky Charlie; 08-16-2010 at 06:24 PM.
CC
If you feel really indebted please consider a donation to charity. My preferred charity is ActionAid but there are plenty of worthy alternatives.
Further to CC's point - if the link is external and closed (implied by the path) then the native INDIRECT will not work I'm afraid (requires open target).
If that is indeed an issue I would suggest googling/searching the board for the likes of INDIRECT.EXT, and Harlan Grove PULL function
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
drawkcaB 
Register To Reply
Bookmarks