Place this in G1 and copy down the column:

=IF(A1&C1=E1&F1,"A",IF(B1&D1=E1&F1,"B","C"))

HTH
Jason
Atlanta, GA

-----Original Message-----
I'm very new to excel so apologies, here is what I want
to attempt:

I have data in A, B, C, D, E & F

the data in E & F will match either A & C or B & D and
sometimes
neither.

What I would like to do is have a formula in G which
returns a letter,
lets say a, b or c depending on the match.

So: IF E&F MATCH A&C Send letter A, IF E&F MATCH B&D
send letter b,
ELSE send letter C

Any guidance help would be greatly appreciated.
Cheers
GCN504

.