If statement with INDEX MATCH

[jpsimmon]

Trying to incorporate ="NA","", in this formula, having no luck. I want it so when the match-index retrieves a text "NA" it leaves the cell blank. But still wanting to leave the ERROR.TYPE function in there for future values to be #N/A.

=IF(Key!$C$10>=$G1158,(INDEX(page!$1:$1048576, MATCH($G1158,page!$A:$A,0), MATCH(X$1155,page!$1:$1,0))), ERROR.TYPE(7))

 

[konew1]

Your formula will first check Key!$C$10> =$G1158 and if this is not true will evaluate ERROR.TYPE(7) which is always going to be #N/A
When the IF condition evaluate to TRUE you will always get the result of the INDEX/Match
You might try IFERROR function, but that will apply to errors in addition to #N/A
=IFERROR(INDEX(page!$1:$1048576, MATCH($G1158,page!$A:$A,0), MATCH(X$1155,page!$1:$1,0),"")