Excel Formula to return text when a cell contains certain text

Hello Joshua,

Thank you for your question. The best formula to achieve this is using XLOOKUP.

You can write it as follows:

=XLOOKUP(B2,$E$2:$E$51,$F$2:$F:$51)

where B2 (the lookup value) holds the state code in the line item, column E (the lookup array) holds all the state codes and column F (the return array) holds all the corresponding regions.

E F
NC South East
SC South East
NY North East

I hope this helps.

Kind regards
Marius Barnard
STL