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