Not sure why this happens, but if I use:
=INDIRECT(ADDRESS(MATCH($D$3,'C:\Documents and Settings\rogarl1\My
Documents\[detailed report.xls]report'!$Q:$Q,FALSE)-0,22))
I get $V$12599, which is the cell I expect to see. If I add the
indirect, below, I get 0 and not the text that is in the cell $V$12599.
=INDIRECT(ADDRESS(MATCH($D$3,'C:\Documents and Settings\rogarl1\My
Documents\[detailed report.xls]report'!$Q:$Q,FALSE)-0,22))
Any suggestions?
Thanks in advance,
Ron
Bookmarks