ExcelBanter - How to use indirect function?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to use indirect function? (https://www.excelbanter.com/excel-discussion-misc-queries/128334-how-use-indirect-function.html)

Eric

How to use indirect function?

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

How to use indirect function?

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

--
---
HTH

Bob

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

"Eric" wrote in message
...
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

pinmaster

How to use indirect function?

Hi,

Try this:

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

Cheers!
Jean-Guy

"Eric" wrote:

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

All times are GMT +1. The time now is 05:02 PM.