Error in formula

[Hei]

Hi all,

I am running the following code and it says my formula is wrong

=MAX('NVaR Exposure'!INDIRECT(ADDRESS((MATCH(VALUE("31/12/2008"),'NVaR
Exposure'!E:E,-1)),6,4,TRUE)), 'NVaR Exposure'!INDIRECT(ADDRESS((MATCH
(VALUE("01/11/2008"),'NVaR Exposure'!E:E,-1)),6,4,TRUE)))

=ADDRESS((MATCH(VALUE("01/11/2008"),'NVaR Exposure'!E:E,-1)),6,4,TRUE)
runs fine
and return F12

=Max('NVaR Exposure'!F12:F14) runs as well and returns what I want

I am not sure what is wrong when I reference another worksheet.
Thank you for all your help in advance

 

[Barb Reinhardt]

What does this return?
=ADDRESS((MATCH(VALUE("31/12/2008"),'NVaR Exposure'!E:E,-1)),6,4,TRUE)