Iferror + index/match + vlookup

[annieflanz]

Hello!

Here's some background on this problem. I have one set of data that has the grade information for students from System A. Then, I have to upload the data into System B. System A and System B do not have the same names for the students (System A has nicknames, etc). So, I need a formula that will check System A's names against System B's names in multiple ways so as to return the correct grade for each student. I cobbled together a formula using IFERROR, INDEX/MATCH and VLOOKUP. Here it is:

=IFERROR((INDEX(n101scores,MATCH(1,(n101first=m5)*(n101last=n5),0),3),VLOOKUP(N5,N101LastScore,2,FALSE)),VLOOKUP(M5,N101 Scores,3,FALSE))

But of course, it's not working.

Here's what I'm trying to accomplish with each sub formula:

IFERROR: I need to return data without errors

(INDEX(n101scores,MATCH(1,(n101first=m5)*(n101last=n5),0),3): Checks for the first and last names of each student in System B's data against System A's data and returns the grade from System A

VLOOKUP(N5,N101LastScore,2,FALSE): If there's an error in the above formula, this would check only the last names in System A against the last names in System B and return the correct grade

VLOOKUP(M5,N101Scores,3,FALSE): If there's still an error, this would check only the first names in System A against the first names in System B and return the correct grade

Any help in getting this formula right would be much appreciated!

[6StringJazzer]

This thread has been duplicated in Commercial Services.

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.