jase71ds
Board Regular
- Joined
- Oct 23, 2006
- Messages
- 137
- Office Version
- 365
- Platform
- Windows
Apparently I'm an idiot...
This has me stumped. I've tried SUMPRODUCT, various array formula (Ctrl+Shift+Enter), non-array formula, VLOOKUP, XLOOKUP, INDEX/MATCH)
At this point I've developed a Glazed-Over mental block. So now I'm reaching out to the sane Excel users.
I think the uploaded image thoroughly explains what I'm trying to achieve.
Thanks for any help offered. I know everyone's time is valuable and so I appreciate any charity on this matter.
Jase.
This has me stumped. I've tried SUMPRODUCT, various array formula (Ctrl+Shift+Enter), non-array formula, VLOOKUP, XLOOKUP, INDEX/MATCH)
At this point I've developed a Glazed-Over mental block. So now I'm reaching out to the sane Excel users.
I think the uploaded image thoroughly explains what I'm trying to achieve.
Thanks for any help offered. I know everyone's time is valuable and so I appreciate any charity on this matter.
Jase.