
Akansh Nema
Member
Members

Forum Posts: 11
Member Since:
July 11, 2020
July 11, 2020

Mam,
Kindly have a look at the enclosed attachment and help me.
Regards.

Purfleet
England
Member
Members

Trusted Members

Trusted Members

Forum Posts: 412
Member Since:
December 20, 2019
December 20, 2019

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

Answers Post
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: adam elias
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Lawrence Miu
Jo Saies
Paul Pritchard
Monique Roussouw
Keith Aul
Richard Dunks
Manjula Mangalmurti
Thomas Quidort
Jamie Preece
Bob Smith
Forum Stats:
Groups: 3
Forums: 24
Topics: 6192
Posts: 27146
Member Stats:
Guest Posters: 49
Members: 31847
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
