I just join this forum and like everyone else, I am very new to using excel function feature.
So I have this function: =IF(ISNUMBER(SEARCH("ACURA",A1)),"????"))
A1 cell = "ACURA TL 2010-2016 BODY KIT"
I want to use function above to: 1.Search for keyword ACURA and return the word next to the right of it which is "TL". Is it possible? Can someone please show me how? 2.I want to search for keyword "20" and return the whole word after it which is "2010-2016".
I am trying to build a part filter for our company website which require Make, Model, and Year attributes. All we have is the product names.
Thank you
Aucun commentaire:
Enregistrer un commentaire