IF Formula Returning Incorrect Value

[Sky188]

Good afternoon everyone,

I've got a function that enters a "Territory" of the US depending on what state/province abbreviation is entered (For example, if UT is entered in B1, A1 enters U.S. West).

For some reason I've got an issue where this simple function isn't working properly and is saying that B1 doesn't = "UT" even if it does. If I type "UT" in A2 and use the function =If(A2="UT",1,0), it works just fine.

To add to the strangeness, My formula works for the vast majority of my cells, but doesn't for a select few (for example, if B1, B2, B3 and B4 all = "UT", A1, A2, and A3 will return the correct value, but A4 will return the incorrect value, even though they have the same formula).

So far I've tried inserting additional columns and cut-pasting the state/province cells into the new column, but it still doesn't work. I've also cut-pasted the entire worksheet onto a new worksheet and have had the same issue.

[FDibbins]

check your data for extra spaces before and after the text. you can do this by using find/replace (ctrl H) find "space" replace "nothing", so you for "find" just press the space bar once, and then in "replace", leave it blank

let me know how you make out?

[BioRoots]

It might take you a while to do the 52 states but here is what i got
=IF(B1="Ut","west",IF(B1="fl","east",""))