If function with multiple text to return a value

[zgraves]

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 want to be able to automatically return the "River Pointe Pl" if true and "Clubhouse Ct." if not.

Thanks

[#2]

@zgraves 

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