Lookup based on 2 values

[636steve]

Hi

Hoping you can help,
I need to find a value based on one value selected from a drop down list and also a value in a cell.

On the attached spreadsheet a class is selected from a drop down list on cell C5

The target cells (colum J)for each row then need to be populated with the value on sheet2 that corresponds with the persons name and the class selected

e.g class B is selected so the value of the target cell for Fred should be the value in sheet 2 cell D13.

I hope this makes sense.

Steve