If nested index match

I had an issue earlier with getting the index match, Thank so much for helping me out FDubbins. it worked great. You said do the if function after everything works, I tried and I've gotten #Value? as the output.

original formula: =INDEX('Student Data'!$B$8:$K$94,MATCH('Lesson Data'!$B3,'Student Data'!$A$8:$A$94,0),MATCH('Lesson Data'!F$2,'Student Data'!$B$7:$K$7,0))

If function formula: =IF (INDEX('Student Data'!$B$8:$K$94,MATCH('Lesson Data'!$B3,'Student Data'!$A$8:$A$94,0),MATCH('Lesson Data'!F$2,'Student Data'!$B$7:$K$7,0)),"")

NOT working, what am I doing wrong? I've played around adding and removing different things but no luck. I want the cell to remain blank and not with the value 0 in there.

That was what I had before I reread the instructions that say: In cell F3 add a Match function nested in an Index function to retrieve the skill levels of each student listed in column B. To prevent zeros from showing when skill level is not known, nest the Match and Index function in an IF function to leave the cell blank when the skill level is 0.

I tried it with both IF and IFERROR, I'm missing something it's simple I know it but I can't figure it out!!!

Thanks. I appreciate it.

Thanks for asking. You've have been a great help!!!This is what I ended up with.{=IFERROR(INDEX('Student Data'!$B$8:$K$94,MATCH('Lesson Data'!$B3,'Student Data'!$A$8:$A$94,0),MATCH('Lesson Data'!F$2,'Student Data'!$B$7:$K$7,0)),"")}
I thought it worked but... there is still a 0 showing up in the column, I've tried changing from exact match but that didn't work either. I'm ready to give up.

I just thought of something. Would it be possible to use just the IF and put the whole Index function as if it's true and put "" if false?

Were you ever able to figure this out? I am currently working on figuring out how to do this and would love some help.

Testing for error, and testing for 0 are 2 different things. (0 is NOT an error)

You'd have to do

=IFERROR(IF(yourindexformula=0,"",yourindexformula),"")