Structured Reference

tommygirl_73703 

You said just now: "in cell M2 the formula used is =[@[Subject Leader]]"

But in the assignment you posted in your very first message the instructions read as follows:

"in cell M2, enter a formula using a nested IF function and structured references to determine first....." [emphasis in the original]

So my question remains: what is the nested IF function that you've attempted to write in cell M2? 

I don't understand at all how =[@[Subject Leader]] can even come close (for you OR your professor) to satisfying the assignment. What is going on there?

And if you can post a picture, posting the actual spreadsheet uses the same method; I appreciate that it can be confusing to navigate this website, but you've managed with all these other steps. Please do yourself the favor of posting the actual spreadsheet.