Hi all

Please help with the following

say I have the following groupings that I need to implement
group1: A,B,C
group2: D.E,F
group3 : G,H,I
etc.

how can I do the following
column 1 is input column where I will be inputting the alphabetical value, I would like excel to classify the grouping accordingly in column 2. Such that If i input the value "H" in column 1, column 2 will calculate this value as belonging to group "3"

any help please