A million thanks to you Pete.

Fish

"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.hondafit.c om",IF(F8113="odyssey","www.hondaodyssey.com","")) ))