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

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?

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?

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?

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?

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?

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?