Concatenate and Wildcards Problem

[dickpierce]

Hello!

I've concatenated some cells in order to use VLOOKUP. So for example, I concatenated Oklahoma with Alabama which gives me OklahomaAlabama so when I use VLOOKUP I get the desired result. However, I'm getting results from cells with data such as OklahomaSouth Alabama which I don't need. I'm using the following wildcard: "*"&"Alabama" but it's not excluding the South part.

Thanks in advance.

 

[pgc01]

You're welcome.