I was going to suggest similar but using Binary Search INDEX/MATCH given the data on bc is already sorted appropriately.
I was going to suggest a concatenation on bc sheet of:
=$A2&"@"&$B2&"@"&$C2
copied down
Followed by summary calc of:
H2:
=LOOKUP(9.99E+307,CHOOSE({1,2},0,IF(VLOOKUP($E2&"@"&$F2&"@"&$G2,bc!$F$2:$F$50924,1)=$E2&"@"&$F2&"@"&$G2,INDEX(bc!$D$2:$D$50924,MATCH($E2&"@"&$F2&"@"&$G2,bc!$F$2:$F$50924)))))
copied down
the above should prove to be a lot quicker than conducting exact matches over such a vast range
(0 implies no match - a Custom Format can be used to have the 0's display however you want)
Bookmarks