I have a very large data set and I need to identify product skus and perform a v-lookup or similar to identify certain products and return a value.
the issue I have is that I want to look up using a partial sku
for example I have a list as below that I want to look up from and take the return value from:
CPVP-VEE
CPXP-CI-VPX
CPMP-SCPRO
but the look up will be against a series of product skus such as
CPVP-VEE- U
CPVP-VEE-U-HA
CPVP-VEE-100
CPVP-VEE-100-HA
CPVP-VEE-U-NG
CPVP-VEE-250
CPVP-VEE-250-HA
CPXP-CI-VPX-U
CPXP-CI-VPX-100
CPXP-CI-VPX-50
CPMP-SCPRO-U
CPMP-SCPRO-250
CPMP-SCPRO-HA
can anyone advise how I would do this?
Thanks
Bookmarks