How to use indirect function?

[Guest]

Does anyone know how to use indirect functionj?
=MIN(Sheet2!A1:A500), I would like to add an integer on B colume
=Indirect("MIN(Sheet2!A"&1+B1&":A3"), but it returns #REF!.
Does anyone have any suggestion how to apply Indirect function to perform
above task?
Thanks you in advance
Eric

 

[Bob Phillips]

=MIN(INDIRECT("Sheet2!A"&(1+B1)&":A3"))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Hi,

Try this:

=MIN(INDIRECT("Sheet1!A"&1+B1&":A3"))


Cheers!
Jean-Guy