
Majesty OJ
New Member
Members

Forum Posts: 1
Member Since:
November 20, 2019
November 20, 2019

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.

SunnyKow
Puchong, Malaysia
VIP
Members

Trusted Members

Trusted Members

Forum Posts: 1432
Member Since:
June 25, 2016
June 25, 2016

Hi
You can refer here for examples on how to get the Product SKU.
https://www.myonlinetraininghu.....t-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
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Ngoc Tinh, Dieneba NDIAYE, Lavina Dhanwani, Natasha Smith, Monique Roussouw
Guest(s) 11
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Denise Lloyd
michael serna
mashal sana
Tiffany Kang
Leah Gillmore
Sopi Yuniarti
LAFONSO HERNANDEZ
Hayden Hao
Angela chen
Sean Moore
Forum Stats:
Groups: 3
Forums: 24
Topics: 6216
Posts: 27252
Member Stats:
Guest Posters: 49
Members: 31897
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —
