non-array formula with multiple lookups

OK .. so I have this formula and it works flawlessly. Except for the fact that it is an array and it's apart of my macro and I have to manually make it an array for it to work. I have over 40 pages that I would have to manually go do so that's not gonna work for me. I know there's away to get it to do it with like a vlookup maybe but I cannot get it to work. So here's what my formula is:

=INDEX(Updated!$E$2:$E$667,MATCH($A$1,IF(Updated!$B$2:$B$667=B2,Updated!$A$2:$A$667,),0))

Basically I have multiple students who take multiple tests. I want to find the score for a particular test based on the students name.

A1 contains the students name
B2 contains the course list
Updated!B2:b667 has all the courses
Updated!A2:A667 has all the students names
Updated!E2:E667 has all the scores

Any help would be appreciated.

how do you define the array within the macro? I have to manually go into the cell and hit ctrl+shift+enter? and I tried that formula but no luck so far.

=LOOKUP(2,1/((Updated!$ B$2:$B$667=B2)*(Updated!$A$2:$A$667=$A$1) ),Updated!$E$2:$E$667)


What is the 2, 1/ for?