Matching Cells/columns
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
|