P
Pilar Morales
This formula returns REF#!
=1*(INDEX(x!$A$1:$AW$128,MATCH($A$27,x!$A$2:A500),MATCH(N7,x!$B$1:$AV$1)))
The values are correct in the evaluate formula box, Row:10, Col 2, but then
it breaks down.
I'e also tried
INDEX(x!$A$1:$AW$128,MATCH($A$27,x!$A$2:A500),MATCH(N7,x!$B$1:$AV$1))
I need the formula to return the value in that cell (in this case, B10)
What am I doing wrong?
Thank you!
=1*(INDEX(x!$A$1:$AW$128,MATCH($A$27,x!$A$2:A500),MATCH(N7,x!$B$1:$AV$1)))
The values are correct in the evaluate formula box, Row:10, Col 2, but then
it breaks down.
I'e also tried
INDEX(x!$A$1:$AW$128,MATCH($A$27,x!$A$2:A500),MATCH(N7,x!$B$1:$AV$1))
I need the formula to return the value in that cell (in this case, B10)
What am I doing wrong?
Thank you!