please see attached - any help to achieve the yellow area results
Both worksheets in reality are huge, and seperate files. I have explored an INDEX helper column and VLOOKUPs with no luck. I would prefer to avoid SUMPRODUCT as the spreadsheets really slow down.
Any help really appreciated :-)
Bookmarks