guscrouchend
Board Regular
- Joined
- May 11, 2010
- Messages
- 94
Hi,
At the moment, a column is populated by:
=IF(ISERROR(MATCH($C5,PriceTable!$F$1:$F$9,0)),"Grad","Senior")
So, if the value in column C is one of the values in range PriceTable!$F$1:$F$9, then the cell is "Senior". If not, it is "Grad".
What I would like is to introduce the third value "Trial" if the value in column C contains an asterisk.
If it does not contain an asterisk, the cell must follow the above formula.
Does anyone know if or how this could be done?
At the moment, a column is populated by:
=IF(ISERROR(MATCH($C5,PriceTable!$F$1:$F$9,0)),"Grad","Senior")
So, if the value in column C is one of the values in range PriceTable!$F$1:$F$9, then the cell is "Senior". If not, it is "Grad".
What I would like is to introduce the third value "Trial" if the value in column C contains an asterisk.
If it does not contain an asterisk, the cell must follow the above formula.
Does anyone know if or how this could be done?