HI,
On 20 different spreadsheets, Column K has a value (scores) that needs to appear in column E or F (depending on the spreadsheet/different grades/years) when the district number and school number (columns B and D for schools) that match in each of the spreadsheets for the comparison spreadsheet I am building.

I tried lookup, but doesn't work when matching two criteria.

I think it is index and match but do not understand the syntax well enough on the help files I have accessed to write it myself.

Any and all help greatly appreciated.

for forum 4.xlsx

Gratefully,
Synthia