INDEX error

[MAX]

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

 

[Sheeloo]

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]

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]

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

 

[Sheeloo]

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

 

[MAX]

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]

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]

Thanks a lot.

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,))

 

[David Biddulph]

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)) ?