Forum Discussion
Solved
trying to keep the box blank unless the other boxes used are filled
Hello, I am using this formula which works but I keep getting the "#N/A" in the box until an adjacent box is filled in to give the formula answer. Can someone please assist with having the formul...
=IFERROR(INDEX($AF$2:$AK$19,MATCH($I11,$AG$2:$AG$19,0),MATCH($J$1,$AF$1:$AK$1,0)),"")
You can wrap the formula into IFERROR.
=IFERROR(INDEX($AF$2:$AK$19,MATCH($I11,$AG$2:$AG$19,0),MATCH($J$1,$AF$1:$AK$1,0)),"")
You can wrap the formula into IFERROR.
- Thank you, I am not versed enough to know how to use that iferror formula so I appreciate you helping me out.
