Thanks for the suggestions and help, Steve. Made some changes with the table and was able to get the correct results. Used the same formula (expression) though.

here’s the result of the given suggestion,

hi steve, tried your suggestion but still get the same result, only HIGH value is displayed

hi, need help with my expression using LOOKUP(). been getting only 1 result value from the lookup table (Risk Scale), and that result is the text value “High”. other values are blank or no result. LOOKUP(CONCATENATE(SELECT(Consolidated Risks[Risk Rat...