If formula not working right

[zone709]

Hi trying to get this to work, but returns nothing blank. What am I missing? If name is present return that number ,1 ,2 or ,3

=IF(R2="Yard",1,IF(R2="Yards",2,IF(R2="Tunnel",3,"")))

 

[jtakw]

Hi,

Personally, I'd go with the formula setup as suggested by Scott in Post # 9.

But just fixing your IF statement, you have """" at the end, change that to ""

 

[zone709]

Hi ok i just tried scotts maybe ill use this thanks. Also the "" works now thanks for the reply

 

[jtakw]

You're welcome, in case you need this:

=IFERROR(MATCH(TRIM(R2),{"Yard","Yards","Tunnel","River"},0),"")