grouping using index

[irvgotti]

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

[FDibbins]

You could create a small table...
A...1
B...1
C...1
D...2
etc
and then use a vlookup to return the value based on the lettter?

[irvgotti]

My knowledge of excel is very minimal could you expand on this please in terms of the formula i would use to return the group value