Excel2003 ... Need Formula in Col D of TabSheet1 that will compare values in
Cols A, B, C of TabSheet1 with values of Cols A, B, C in Tabsheet2 & then
return value found in Col G of Tabsheet2 to Col D of Tabsheet1.

Note:

Cols A,B,C = Text (both TabSheets)
TabSheet2 Col G is a DATE (mm/dd/yy) which I wish to get populated into
TabSheet1 Col D when all 3 criteria match.

So far my attempts with SUMPRODUCT are returning the #Value error.

Thanks ... Kha