Forum Discussion
Solved
Help with excel formula
Hello. I really need urgent assistance with a formula in excel please. I have been trying for days!
I created a risk metrics which should have a dropdown with the likelihood and dropdown for consequence and then the result should appear in the same colour low, med, high..
Can someone please assist me urgently.
This is the formula in cell E11 in the attached example. The formula is copied down to cell E24 and the dropdowns are in range C11:D24. Conditional formatting is entered for range E11:E24.
=IFERROR(INDEX($C$3:$G$7,MATCH(C11,$B$3:$B$7,0),MATCH(D11,$C$2:$G$2,0)),"")
This is the formula in cell E11 in the attached example. The formula is copied down to cell E24 and the dropdowns are in range C11:D24. Conditional formatting is entered for range E11:E24.
=IFERROR(INDEX($C$3:$G$7,MATCH(C11,$B$3:$B$7,0),MATCH(D11,$C$2:$G$2,0)),"")- Thank you so much for this!.. Much much appreciated.
- How would you attached what you just sent me to an existing excel spreadsheet?
