| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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","")) )) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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","")))) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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","")) )) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with a wildcard search | Excel Discussion (Misc queries) | |||
| wildcard characters | Excel Discussion (Misc queries) | |||
| HELP: Wildcard Characters | Excel Discussion (Misc queries) | |||
| using the wildcard ? in formulas | Excel Discussion (Misc queries) | |||
| sum if wildcard | New Users to Excel | |||
Linear Mode
