Retrieving Data Using IF and INDEX Formula

[mack_76]

Hi

Based on previous advice from the forum I have created the attached. At each point the learner name changes I want to bring thru their data. I have achieved this within the analysis tab but I am now trying to work in an additional IF under the Attainment Grid tab.

When I change the learner name I want to bring thru the data to show specifically in each relevant cell i.e.

IF @ Aut1 Eng Grade = 1A enter 1A in cell E42 if not leave blank

Can anyone help please?

Cheers
Mack_76