To insert the risk category according to the score

[Andry79]

Hi,

I kindly need a formula in the highlighted fields in the attached spreadsheet whereby a certain score corresponds to the related risk category (in wording).

Thank you.

Best,

Andry

[AliGW]

Change the lookup table to this:

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	B	C
2	Risk Category	Risk score
3	Low	1
4	Medium	4
5	High	9
6	Extreme	15

Sheet: Sheet1

Then this in G1:

=XLOOKUP($F$3:$F$15,$C$3:$C$6,$B$3:$B$6,"",-1)

[AliGW]

Or, if you must keep the table as it is, this:

=XLOOKUP($F$3:$F$15,--TEXTBEFORE($C$3:$C$6,"-"),$B$3:$B$6,"",-1)

[Andry79]

Hi Ali,

Unfortunately, the formula does not given any results

[Andry79]

Thank you Ali! it works now.

Appreciated as usual.