Hi, we need to do a “reverse partial lookup”.
i.e. we have a list of old_product_codes (Col A) and new_product_codes (col B).
And we need to know if any of the new_product_codes contain (or equal) any of the old_product_codes
We have found ways of making this work on smaller lists, but we now have 317K new_product_codes and 40,000 old_product_codes.
And any method we have tried has timed out. Or crashed Excel.
If you have any suggestions, we would gladly take a look!
Quick Sample:
<tbody>
</tbody>
i.e. we have a list of old_product_codes (Col A) and new_product_codes (col B).
And we need to know if any of the new_product_codes contain (or equal) any of the old_product_codes
We have found ways of making this work on smaller lists, but we now have 317K new_product_codes and 40,000 old_product_codes.
And any method we have tried has timed out. Or crashed Excel.
If you have any suggestions, we would gladly take a look!
Quick Sample:
Old_product_does(smaller list) | blank | new_product_codes(larger list) | blank | contain or equals | ||
<tbody> </tbody> | ZV374 | Y | ||||
<tbody> </tbody> | ASSN01958141222 | Y | ||||
<tbody> </tbody> |
<tbody> </tbody> | N | ||||
<tbody> </tbody> |
<tbody> </tbody> | N | ||||
1111ZVN0106B16 | Y | |||||
<tbody> </tbody> | N | |||||
<tbody> </tbody> | N | |||||
<tbody>
</tbody>