Searching a table and returning a corresponding number

Hello,

So i have some student data I'm trying to streamline.

I have a column (I) labeled MI Growth, this column is filled with a number from the MI Levels sheet. It takes the score from column (G) labeled MI Score and finds the corresponding grade and sure range on the MI Level sheet.

I hope this is somewhat clear.

I have included a sample file with desired outcomes started.

Thanks in advance for any and all assistance in this matter

Los

In I4

=IF(B4="","",INDEX('MI Levels'!$C$3:$I$15,MATCH($G4,'MI Levels'!$B$3:$B$15,1),MATCH($C4,'MI Levels'!$C$2:$I$2,0)))

copy down

I add ed extra column B in MI Levels

thanks that worked like a charm!!!

Los