INDEX error
 

I have a formula in a cell (A2+A3). It is possible that I enter an INDEX
function in the same cell?

INDEX error
 

One cell can have only one formula... You can of course embed functions
within one another...
=SUM(IF(A1=5,10,20) + IF(A2=10,40,50)))

also it can not reference the cell it is entered in...

"MAX" wrote:

I have a formula in a cell (A2+A3). It is possible that I enter an INDEX
function in the same cell?

INDEX error
 

I have cell AV6=(AT6+AU6) and I want to enter this function in cell AV6 too,
=INDEX(Av$6:Av$25,MATCH(ROW()-1,$ax$6:$ax$25,)). What is the solution?

"Sheeloo" wrote:

One cell can have only one formula... You can of course embed functions
within one another...
=SUM(IF(A1=5,10,20) + IF(A2=10,40,50)))

also it can not reference the cell it is entered in...

"MAX" wrote:

I have a formula in a cell (A2+A3). It is possible that I enter an INDEX
function in the same cell?

INDEX error
 

Try this in AV^
=INDEX((AT$6:AT$25)+(AU$6:AU$25),MATCH(ROW()-1,$AX$6:$AX$25,))
and copy down... till AV25

"MAX" wrote:

I have cell AV6=(AT6+AU6) and I want to enter this function in cell AV6 too,
=INDEX(Av$6:Av$25,MATCH(ROW()-1,$ax$6:$ax$25,)). What is the solution?

"Sheeloo" wrote:

One cell can have only one formula... You can of course embed functions
within one another...
=SUM(IF(A1=5,10,20) + IF(A2=10,40,50)))

also it can not reference the cell it is entered in...

"MAX" wrote:

I have a formula in a cell (A2+A3). It is possible that I enter an INDEX
function in the same cell?

INDEX error
 

Correction -
Try the forumula in AV6... not AV^

:-)

"Sheeloo" wrote:

Try this in AV^
=INDEX((AT$6:AT$25)+(AU$6:AU$25),MATCH(ROW()-1,$AX$6:$AX$25,))
and copy down... till AV25

"MAX" wrote:

I have cell AV6=(AT6+AU6) and I want to enter this function in cell AV6 too,
=INDEX(Av$6:Av$25,MATCH(ROW()-1,$ax$6:$ax$25,)). What is the solution?

"Sheeloo" wrote:

One cell can have only one formula... You can of course embed functions
within one another...
=SUM(IF(A1=5,10,20) + IF(A2=10,40,50)))

also it can not reference the cell it is entered in...

"MAX" wrote:

I have a formula in a cell (A2+A3). It is possible that I enter an INDEX
function in the same cell?

INDEX error
 

Why you left out AV$6:AV$25, from this function
=INDEX(Av$6:Av$25,MATCH(ROW()-1,$ax$6:$ax$25,))

Another question: I have cell AW6=(AQ6*3)+(AR6*1) and I want to enter this
function in cell AW6 too =INDEX(AW$6:AW$25,MATCH(ROW()-1,$ax$6:$ax$25,)),
what is the solution?

"Sheeloo" wrote:

Correction -
Try the forumula in AV6... not AV^

:-)

"Sheeloo" wrote:

Try this in AV^
=INDEX((AT$6:AT$25)+(AU$6:AU$25),MATCH(ROW()-1,$AX$6:$AX$25,))
and copy down... till AV25

"MAX" wrote:

I have cell AV6=(AT6+AU6) and I want to enter this function in cell AV6 too,
=INDEX(Av$6:Av$25,MATCH(ROW()-1,$ax$6:$ax$25,)). What is the solution?

"Sheeloo" wrote:

One cell can have only one formula... You can of course embed functions
within one another...
=SUM(IF(A1=5,10,20) + IF(A2=10,40,50)))

also it can not reference the cell it is entered in...

"MAX" wrote:

I have a formula in a cell (A2+A3). It is possible that I enter an INDEX
function in the same cell?

INDEX error
 

1. Because AV$6:AV$25 is the same as
(AT$6:AT$25)+(AU$6:AU$25) if you wanted to add them in AV and also use the
INDEX/MATCH function...

2. Try
=INDEX((AQ$6:AQ$25)*3+(AR$6:AR$25),MATCH(ROW()-1,$AX$6:$AX$25,))

"MAX" wrote:

Why you left out AV$6:AV$25, from this function
=INDEX(Av$6:Av$25,MATCH(ROW()-1,$ax$6:$ax$25,))

Another question: I have cell AW6=(AQ6*3)+(AR6*1) and I want to enter this
function in cell AW6 too =INDEX(AW$6:AW$25,MATCH(ROW()-1,$ax$6:$ax$25,)),
what is the solution?

"Sheeloo" wrote:

Correction -
Try the forumula in AV6... not AV^

:-)

"Sheeloo" wrote:

Try this in AV^
=INDEX((AT$6:AT$25)+(AU$6:AU$25),MATCH(ROW()-1,$AX$6:$AX$25,))
and copy down... till AV25

"MAX" wrote:

I have cell AV6=(AT6+AU6) and I want to enter this function in cell AV6 too,
=INDEX(Av$6:Av$25,MATCH(ROW()-1,$ax$6:$ax$25,)). What is the solution?

"Sheeloo" wrote:

One cell can have only one formula... You can of course embed functions
within one another...
=SUM(IF(A1=5,10,20) + IF(A2=10,40,50)))

also it can not reference the cell it is entered in...

"MAX" wrote:

I have a formula in a cell (A2+A3). It is possible that I enter an INDEX
function in the same cell?

INDEX error
 

Thanks a lot.

"Sheeloo" wrote:

1. Because AV$6:AV$25 is the same as
(AT$6:AT$25)+(AU$6:AU$25) if you wanted to add them in AV and also use the
INDEX/MATCH function...

2. Try
=INDEX((AQ$6:AQ$25)*3+(AR$6:AR$25),MATCH(ROW()-1,$AX$6:$AX$25,))

"MAX" wrote:

Why you left out AV$6:AV$25, from this function
=INDEX(Av$6:Av$25,MATCH(ROW()-1,$ax$6:$ax$25,))

Another question: I have cell AW6=(AQ6*3)+(AR6*1) and I want to enter this
function in cell AW6 too =INDEX(AW$6:AW$25,MATCH(ROW()-1,$ax$6:$ax$25,)),
what is the solution?

"Sheeloo" wrote:

Correction -
Try the forumula in AV6... not AV^

:-)

"Sheeloo" wrote:

Try this in AV^
=INDEX((AT$6:AT$25)+(AU$6:AU$25),MATCH(ROW()-1,$AX$6:$AX$25,))
and copy down... till AV25

"MAX" wrote:

I have cell AV6=(AT6+AU6) and I want to enter this function in cell AV6 too,
=INDEX(Av$6:Av$25,MATCH(ROW()-1,$ax$6:$ax$25,)). What is the solution?

"Sheeloo" wrote:

One cell can have only one formula... You can of course embed functions
within one another...
=SUM(IF(A1=5,10,20) + IF(A2=10,40,50)))

also it can not reference the cell it is entered in...

"MAX" wrote:

I have a formula in a cell (A2+A3). It is possible that I enter an INDEX
function in the same cell?

INDEX error
 

I assume that you intended either
=IF(A1=5,10,20) + IF(A2=10,40,50)
=SUM(IF(A1=5,10,20) , IF(A2=10,40,50)) ?
--
David Biddulph

Sheeloo wrote:
One cell can have only one formula... You can of course embed
functions within one another...
=SUM(IF(A1=5,10,20) + IF(A2=10,40,50)))

also it can not reference the cell it is entered in...

"MAX" wrote:

I have a formula in a cell (A2+A3). It is possible that I enter an
INDEX function in the same cell?