Forum Discussion

Nikkie1977

Copper Contributor

Jul 11, 2022

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...

Formulas and Functions

OliverScheurich
Jul 11, 2022
Nikkie1977
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)),"")
risk metric.xlsx9 KB

OliverScheurich

Gold Contributor

Jul 11, 2022

Nikkie1977

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)),"")

risk metric.xlsx9 KB

Nikkie1977

Copper Contributor

Jul 11, 2022

Thank you so much for this!.. Much much appreciated.

Nikkie1977
Copper Contributor
Jul 11, 2022
How would you attached what you just sent me to an existing excel spreadsheet?
- OliverScheurich
  Gold Contributor
  Jul 11, 2022
  Nikkie1977
  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.
  - Nikkie1977
    Copper Contributor
    Jul 12, 2022
    OliverScheurich Sorry about that.
    
    Below i have attached what the top of the excel document looks like as well as where the formulas should be. Column E should be the likelihood dropdown, F Consequence dropdown and G the Risk level result. Appreciate your help so much thank you!