Column A has values Green, Red, Blue.
Column B has values Circle, Triangle, Square.
Column C has values 1, 2, 3.
What I wish to accomplish is that Column C has a value based on A and B
If Column A=Green and B=Circle, then C=1
If Column A=Red and B=Triangle, then C=2
If Column A=Blue and B=Square, then C=3
If A and B have any other combinations, display no value.
I can make work if I use:
BUT how do I add all conditions in one cell so whatever
combination I need is automatically created?
I dont know what to put between two or more IF-clauses.
Semicolon is wrong:
Any help is very much appreciated.