If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Link based on Cell Value
Oops - forgot to mention I'm trying to retrieve more than a single cell with one function call, i.e. I'd like to specify a range, and return a sum (other operations would be nice, too). Morefunc/indirect.ext only returns a single cell. Thanks in advance!
|
#2
|
|||
|
|||
Link based on Cell Value
Dave Bogot wrote:
I'd like to specify a range, and return a sum (other operations would be nice, too). I don't know of any "off the shelf" solution. I can think of no way to do it within Excel. An XLL function similar to INDIRECT.EXT might be able to be written to do what you want, but not by me. Your best bet might be to contact Laurent Lonrge, the author of INDIRECT.EXT, via his website ( http://longre.free.fr/english ). He might be prepared to develop a solution for you. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Thread Tools | |
Display Modes | |
|
|