I think you will need to do it like this:

=IF(ISNUMBER(SEARCH("accord",F8113)),"www.hondaacc ord.com",IF(ISNUMBER(SEARCH("civic",F8113)),"www.h ondacivic.com",IF(ISNUMBER(SEARCH("fit",F8113)),"w ww.hondafit.com",IF(ISNUMBER(SEARCH("odyssey",F811 3)),"www.hondaodyssey.com",""))))

Hope this helps.

Pete


On Oct 1, 12:05*am, Fish wrote:
I have a list of Honda terms as:
accord ex-l v6 used
certified pre owned civic coupe
accord sedan used
certified pre owned pilot 4wd ex
certified pre owned element 2wd lx
I want to be able to look-up the model accord, civic... and return the
specified URL for that model...www.hondaaccord.com,www.hondacivic.com...
this is what i have tried with different variations using * and ~ and still
cannot get it to work.
=IF(F8113="accord","www.hondaaccord.com",IF(F8113= "civic","www.hondacivic.com",IF(F8113="fit","www.h ondafit.com",IF(F8113="odyssey","www.hondaodyssey. com",""))))