Forum Discussion
Help with excel formula
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)),"")
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.
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!
From the picture i'm not sure which columns contain which data but for my suggestion i assumed that the columns and data are arranged as indicated here:
=IFERROR(INDEX($C$8:$G$12,MATCH(E42,$B$8:$B$12,0),MATCH(F42,$C$7:$G$7,0)),"")In the attached file in sheet "Tabelle2" i entered this formula in cell G42 and copied it down to cell G46.