Comparing two columns in two different excel spreadsheets

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 S...