Forum Discussion
If function with multiple text to return a value
Hello! I'm a novice at this. I get errors when I use this formula: =IF(T5="3960","3981","3980","3991","4020"),"River Pointe Pl.","Clubhouse Ct.") In column T, I have different numbers and I wa...
Use
=IF(OR(T5={"3960","3981","3980","3991","4020"}),"River Pointe Pl.","Clubhouse Ct.")
By the way, are you sure that T5 contains a text value that looks like a number? If T5 contains a 'real' number, change the formula to
=IF(OR(T5={3960,3981,3980,3991,4020}),"River Pointe Pl.","Clubhouse Ct.")