Forum Discussion
If or ifs and search function
Hi, I am trying to do a simple if or ifs statement which includes the search function. I want the search to look at the 1st column and search if it is adsl it is one price and if it is vdsl it i...
WOuldn't it be better to use VLOOKUP to look up ADSL or VDSL from a list?
JKPieterseThanks but I have 1 ADSL value which needs to be used for any kind of ADSL xxx (it doesn't matter what comes ADSL) type hence the search function. Same for VDSL.
