Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
70
Views
Topic starter
Mam,
Kindly have a look at the enclosed attachment and help me.
Regards.
Posted : 20/08/2020 7:39 am
Its better if you put the question on the message board rather than in the file, so we can see what you are after easier.
I have added a helper column for ease in column F which is just a COUNTA (=COUNTA(C2:E2))
Then index and match =INDEX(B2:B11,MATCH(H11&"3",A2:A11&F2:F11,0)) i find index and match much more flexible that vlookups.
If there are examples in your data with products where more than 1 all activities are complete then this will only find the first, but its a start
Posted : 20/08/2020 1:08 pm
Topic starter
Thanks Purfleet it worked perfectly.
Posted : 06/09/2020 11:38 am
