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.