I have a sheet that looks up data and returns either 3A 3B 3C or 3D in one cell and 1, 2 or 3 in the adjacent cell. So two cells side by side.
In a third column I then need that cell to return the appropriate statement that I've entered (in a different sheet within the same workbook) based upon whatever combination of these two things there are. So 12 possible combinations?
So I want to know how to write a formula which will return a outcome for each of the possible outcomes?