Hi PJS,

You can use the Excel function "VLOOKUP" to achieve the desired result. Here are the steps:

1. Create a table with the list of values and their corresponding groups. In your example, the table would have two columns: "States" and "Group".
2. In a separate cell, enter the formula
   Code:

   "=VLOOKUP(A1,Table,2,FALSE)"

   where "A1" is the cell containing the state name, "Table" is the range of cells containing the table you created in step 1, and "2" is the column number containing the group number.
3. Press Enter to see the result. The formula will look up the state name in the table and return the corresponding group number.
4. Copy the formula to other cells as needed.