$$Excel-Macros$$ Indirect Function syntax

I'm trying to figure out how to use a function within the indirect function. for example, I would like to use a sum function within an indirect function so I can change the sum range based on a certain cell value. But I apparently have the wrong syntax. Why does this function return #REF? =

$$Excel-Macros$$ Indirect Function syntax

I'm trying to figure out how to use a function within the indirect function. for example, I would like to use a sum function within an indirect function so I can change the sum range based on a certain cell value. But I apparently have the wrong syntax. Why does this function return #REF? =

$$Excel-Macros$$ Indirect Function syntax

I'm trying to figure out how to use a function within the indirect function. for example, I would like to use a sum function within an indirect function so I can change the sum range based on a certain cell value. But I apparently have the wrong syntax. Why does this function return #REF? =

$$Excel-Macros$$ Indirect Function syntax

I'm trying to figure out how to use a function within the indirect function. for example, I would like to use a sum function within an indirect function so I can change the sum range based on a certain cell value. But I apparently have the wrong syntax. Why does this function return #REF? =

$$Excel-Macros$$ Indirect Function syntax

I'm trying to figure out how to use a function within the indirect function. for example, I would like to use a sum function within an indirect function so I can change the sum range based on a certain cell value. But I apparently have the wrong syntax. Why does this function return #REF? =

$$Excel-Macros$$ Indirect Function syntax

cool thanks. can that same syntax be used for vlookup? for example: =VLOOKUP(INDIRECT("A1,B1:C3,2,FALSE")) -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FO

$$Excel-Macros$$ Indirect Function syntax

I'm trying to figure out how to use a function within the indirect function. for example, I would like to use a sum function within an indirect function so I can change the sum range based on a certain cell value. But I apparently have the wrong syntax. Why does this function return #REF? =

$$Excel-Macros$$ indirect function syntax

I'm trying to figure out the syntax to use a function within the Indirect function. I would like to do something like this but am getting a #REF error: =INDIRECT("SUM(A1:A3)") Where am I going wrong? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,

Re: $$Excel-Macros$$ Indirect Function syntax

Hi MLT, Use this =SUM(INDIRECT("A1:A3")) ** * Best Regards, Ms Excel User * ** On Sun, Jul 21, 2013 at 12:37 AM, MLT wrote: > I'm trying to figure out how to use a function within the indirect > function. for example, I would like to use a sum function within an > in

Re: $$Excel-Macros$$ Indirect Function syntax

Hi, Use this =VLOOKUP(INDIRECT("A1"),B1:C3,2,FALSE) ** * Best Regards, Ms Excel User * ** On Sun, Jul 21, 2013 at 1:08 AM, MLT wrote: > cool thanks. can that same syntax be used for vlookup? > > > for example: > > =VLOOKUP(INDIRECT("A1,B1:C3,2,FALSE")) > > -- > Are you =EXP(

Re: $$Excel-Macros$$ indirect function syntax

. Enjoy Team XLS On Sun, Jul 21, 2013 at 12:54 AM, MLT wrote: > I'm trying to figure out the syntax to use a function within the Indirect > function. I would like to do something like this but am getting a #REF > error: > > =INDIRECT("SUM(A1:A3)") > > > Where am I goi