If and wildcard
 

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","")) ))

If and wildcard
 

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",""))))

If and wildcard
 

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","")) ))

If and wildcard
 

You're welcome - thanks for feeding back.

Pete

On Oct 1, 1:21*am, Fish wrote:
A million thanks to you Pete.

Fish