Hi everyone,

What is the excel fuction for "in list", where cell value equals to a list
of values?

If A1 = "this list of values" then "1" else If A1 = "another list of values"
then "2" ?

end results
if CA is by definition in Group 1, the function would recognize CA and
return the value 1, and NY by definition in Group 2, return the value 2?

States Group
CA 1
NY 2

thanks!

PJS