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

@GwenH 

=INDEX(Sheet2!$H$1:$H$25,MATCH(Sheet1!D1&Sheet1!E1,(Sheet2!$F$1:$F$25&Sheet2!$G$1:$G$25),0))

Maybe like in the attached file.