Match 3 set of columns and return value from another column in case of a unique match.

1) I need to match column B, C & D from 'Product Test Offshore' sheet with
columns C, D & E resp from 'DATA' sheet and in case of a match on all 3,
copy corresponding value from column G from 'Data' sheet into
corresponding column F of 'Product Test Offshore' sheet.

All columns may involve duplicates & unsorted data and column D & E of 'DATA' sheet may involve blank cells.

I tried Index, Match combination for above but not working for me.

Note : Only excel 2003 workable solution needed.


2) In Status summary sheet, I need to pull the count of different
status of differnt business process from Product Test Offshore. Column
A has business process & G has status.
I tried sumproduct, vlookup, count etc but not working.

Note : Only excel 2003 workable solution needed.