On Apr 29, 3:47 pm, "Peo Sjoblom" wrote:
As long as you use it on an address that is not in a closed workbook you can
use INDIRECT

=INDIRECT(ADDRESS(MATCH(1,E3:E5,0)+2,3))

--

Regards,

Peo Sjoblom


And if you look up a freeware set of UDFs call "Morefunc", they have
made an INDIRECT function that works on closed workbooks.