Forum Discussion
Solved
If Function - multiple scenarios
Oops. Duplicate conversation. Thank you all who helped me.
It looks like duplicated conversation
I suggest to introduce two more columns for simplifying the formula. The formula "CHOOSE" will help. As the column H contains error message (#N/A), I don't have ideas to compare with "IF". To solve this, I use "IFERROR" and "VLOOKUP" at the same time and then use "CHOOSE". You may refer to the file attached.