Help with pulling info to another cell based on two criteria

[LWOLL22]

I want a cell to display a number from another sheet in the workbook if two things are true.

For example: on sheet 2, I want information from sheet 1 in column E displayed in sheet 2 column M if sheet 1 matches sheet 2 column A AND sheet 1 column D matches sheet 2 column C. Can someone help me with this formula?

 

[JLGWhiz]

In Sheet 2 cell M2 put

=IF(AND(A2 = Sheet1!A2,Sheet1!D2=C2),Sheet1!E2,"")

then drag down as needed.