Notifications
Clear all
Topic starter
I need to match product filenames (column C) to SKUs (column D) and return the adjacent product name (column E).
Example: The formula should "match" product-redsocks1-small (C2) with redsocks1 (D4) and return adjacent cell value Red Socks (E4).
I'm trying to get the formula to match photo file names in column C with the matching product name (for the photo/file) in column E.
Example table attached.
Posted : 20/11/2019 5:45 pm
Hi
You can refer here for examples on how to get the Product SKU.
https://www.myonlinetraininghub.com/excel-search-string-for-a-list-of-words
=INDEX($D$2:$D$4,SUMPRODUCT(ISNUMBER(SEARCH($D$2:$D$4,C2))*ROW($1:$3)))
You can then use a VLOOKUP or INDEX/MATCH to get the Product Name.
Good luck
Sunny
Posted : 20/11/2019 8:27 pm
