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 cons...
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?
Without seeing the existing spreadsheet i can't tell. Maybe you can attach a picture of your spreadsheet without sensitive data or you can upload your file without sensitive data.
