Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find matching records in two worksheets | Excel Discussion (Misc queries) | |||
Compare cells/columns and highlight matching text strings | Excel Worksheet Functions | |||
Matching an Array in one Tab with an Array with another Tab | Excel Worksheet Functions | |||
Matching cells | Excel Discussion (Misc queries) | |||
Formula for Searching & matching two values in excel | Excel Discussion (Misc queries) |