This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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.
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...