Returning value from a cell

[ron_dallas2001]

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

 

[Jezebel]

Did you leave something out in your message? The two formulas you posted are
identical to my eyes --


A > =INDIRECT(ADDRESS(MATCH($D$3,'C:\Documents and Settings\rogarl1\My
B > =INDIRECT(ADDRESS(MATCH($D$3,'C:\Documents and Settings\rogarl1\My

A > Documents\[detailed report.xls]report'!$Q:$Q,FALSE)-0,22))
B > Documents\[detailed report.xls]report'!$Q:$Q,FALSE)-0,22))

 

[Peo Sjoblom]

I saw that too, I assume the OP shouldn't have included INDIRECT in his
first formula.
The reason it is zero is that the formula w/o INDIRECT will return
$V$12599 thus INDIRECT will look in the same sheet and workbook that holds
the INDIRECT formula
not in the detailed report workbook, he needs to add the workbook name and
sheet name in the address part
like in

INDIRECT(ADDRESS(MATCH($D$3,'C:\Documents and Settings\rogarl1\My
Documents\[detailed report.xls]report'!$Q:$Q,FALSE)-0,22,"[detailed
report.xls]report'"))

regardless INDIRECT will not work on a workbook that is closed so even if he
adds the workbook/sheet name it won't work, it will return a REF error I
believe

--
Regards,

Peo Sjoblom

(No private emails please)