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?
=
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?
=
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?
=
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?
=
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?
=
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
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?
=
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,
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
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(
.
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
11 matches
Mail list logo