Forum Discussion
Nested "if" Excel 2007
Losing. My. Mind. I need to assign a region to each row of a spreadsheet based on the state listed in it. Let's say B1 is the state name. A1 needs to sort those states into North, South, East, ...
Unbelievable. All these hours and that was it. Thank you. THANK YOU!!!
Another CHOICE would be:
=CHOOSE(MATCH(B1,
{“California”,”Minnesota”,
“New York”,”Texas”},0),
“West”,”North”,”East”,”South”)
LOOK no further, I prefer:
=LOOKUP(B1,
{“California”,”Minnesota”,
“New York”,”Texas”},
{“West”,”North”,”East”,South”})
=CHOOSE(MATCH(B1,
{“California”,”Minnesota”,
“New York”,”Texas”},0),
“West”,”North”,”East”,”South”)
LOOK no further, I prefer:
=LOOKUP(B1,
{“California”,”Minnesota”,
“New York”,”Texas”},
{“West”,”North”,”East”,South”})