I'm trying to do an iferror index match, but the value is a word in the column but it is showing blank in the ones that has the words in there. The value needs to be blank if there is no skill level in the particular column but if there is a skill level it needs to put the value/skill level that is listed. What am I doing wrong? This is my formula: =IFERROR(INDEX('Student Data'!A9:A95, MATCH(B9:B95,'Student Data'!J8:J94),match B3:B12110),"") Can anyone help?
lesson5problem.xlsx