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