Hello,
I use Excel frequently at work but am by no means an expert or even very good.
The following formula works for what I want it to do, but I expect there is probably a way I could condense it:
=IF(NOT(ISERROR(MATCH(E6,I86:I92,0))),"ON",IF(NOT(ISERROR(MATCH(E6,I93:I99,0))),"WEST",IF(NOT(ISERROR(MATCH(E6,I100:I105,0))),"EAST",IF(NOT(ISERROR(MATCH(E6,I106:I108,0))),"QUEBEC")))))
Essentially, I am searching a cell (E6) against a range (I85:108) and looking for a match. Depending on which cell it matches, I need the formula to generate the region (ON/WEST/EAST/QUEBEC). I am using a similar formula to drive various formulas throughout my sheet.
If anyone could give me advice on the above, I would be very appreciative.
Thanks
!