I need to look up three cell values from three different columns (but in the same row) in one worksheet, and return the cell value from a 4th column (in the same row) IF the first three values in that worksheet match the 2nd worksheet.

For example, in the attached workbook, I need to look up the cell value for column A2, Column E2, and Column F2 in the Worksheet 1, match those three values in worksheet 2, and if there is a match, return the result from Column N from Worksheet 1 into Column N of Worksheet 2.

Supplier Exception Report Example.xlsx

Some of these reports have hundreds of lines, so any help would be greatly appreciated!

Eva Marie