M
MAX
I have a formula in a cell (A2+A3). It is possible that I enter an INDEX
function in the same cell?
function in the same cell?
S
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...
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...
M
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?
=INDEX(Av$6:Av$25,MATCH(ROW()-1,$ax$6:$ax$25,)). What is the solution?
S
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
=INDEX((AT$6:AT$25)+(AU$6:AU$25),MATCH(ROW()-1,$AX$6:$AX$25,))
and copy down... till AV25
S
Sheeloo
Correction -
Try the forumula in AV6... not AV^
Try the forumula in AV6... not AV^
M
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?
=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?
S
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,))
(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,))
M
MAX
Thanks a lot.
Sheeloo said: