Comparing two columns in two different excel spreadsheets

Occasional Visitor

I am trying to compare columns from two different sheets in two columns that matches to get a value from a 3rd column on the first sheet.    Example, Sheet 1 has Column D and E and I want to search Sheet 2 in columns F, G and H.   D and E  from sheet 1 must match the Row for F and G in sheet 2.  If they match then I need the number that is in H for that same Row.   Can I get some help on what to use, a formula or a function?

Thank you

1 Reply



Maybe like in the attached file.