HI! I am a dummy beginner but very interested in improve my skills. I have
been 4 hours trying to understand the logic on multiple criteria formulas and
I am afraid I am almost going to give up... Someone around could PLEASE help
me?

Suppose I have 10 different type of groups to classify a loooong list of
students according to their interests as follows:

A1: A10 B1:B2
I painting
II dancing
.... ...
X reading

My first question is if I can relate text information (I, II, III, IV...X)
with other text info (B1:B10) so I can obtain an automatic fill of one colum
A or B...
I mean if after I write for example painting the opposite colum will
automatically write the group (I) or the opposite: if I introduce the group
i.e. II, inmediately I can know the activity (dancing)?
I had used a replacement tool before, with other kind of tables BUT after
finishing entering all the information in the chart : I mean after finishing
a list I have used the IF (A1:A10="done"), OK, "error"),
how ever this time I can have 10 diferent possibilities "I", "II",
"III"....."X" and I have being giving circles to relate both columns in a
single step.

As the experts of this space might have notice due to my long mail, I have
few experience, but would really appreciate some help in this! ! !

ps: So far I am deciding one by one the student activity, but if you teach
me, my hope is to make a formula in such a way that with a combination of
letters I could know faster the best group to locate each student, by
defining the criterias (i.e. the student will paint if he love painting, is
not interested in physical activities and has a scolarship--- LP, NO Phy and
SCHP...

I will wait to see if someone can help me at the other side of the world.
Thank you,

Karoline

KBZ