I am trying to automatically categorize location numbers (plants) into
markets. For example, locations 001, 010, 872, 301 and 400 are Market
4..... and locations 210, 300, 501, 777, and 898 are Market 5 ..... and
locations 255, 755, 601, 701, and 901 are Market 6. I'd like to have the
formula automatically type "4", "5" or "6" in the "Market" column based on
the location number. So it would look like this where the market column is
filled automatically.

Location Market
001 4
755 6
777 4
901 6

I appreciate any advice that you may have. Thank you!