View Single Post
  #1   Report Post  
gcn504
 
Posts: n/a
Default 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