IF cant find selection of multiple keywords return "text"

[Eagle75au]

Hi All!

I currently have a formula that checks a cell for multiple versions of text and responds with a version of text that matches that word, kinda ugly longgggggg formula but it works!

Please Login or Register  to view this content.

eg. If "Analogue Copier Toners" is found in a cell then return "Analogue_Copier.jpg" ........ and so on which is copied down 3 or 4000 rows.

What i want to do is extend that formula so that if it doesn't find any of these words then it returns "No_Image.jpg"

reason we need this is for our spreadsheet that populates an online store with about 4000 products!


Thanks

[protonLeah]

Hi, welcome to the forum. Please take a moment to read the forum rules and then amend your thread title and add code tags around your code.

[benishiryo]

hi Eagle75au, u can use this formula:

Please Login or Register  to view this content.

but i rather u do up a list to VLOOKUP. attached an eg for u. it'll be easier to maintain

[Eagle75au]

Thanks for your help!