I’m using the LOOKUP expression to find the value of a column named Type and matching that text with a table of values to find the correct Rate for each Type. This was working great until I realized that the Type column needed to be an enumerated list. Lookup can’t compare list values with text values…

Is there a different expression I can use here?

This is what I had. Calculated Rate=LOOKUP([Type], “Enumeration”, “Work Item”, “Rate”)