a$.$ In cell I$6,$ enter a formula using the XLOOKUP function to look up the claim type. Use a structured reference to look up the value in the Claim Code column.

b$.$Use the Codes named range on the Lookups worksheet as the lookup array. Return the corresponding value from the Claim$\_$Types named range on the Lookups worksheet.

c$.$Specify an exact match or next larger item $(1)$ as the match mode.

$$Fill the formula into the rest of the Claim Type column, if necessary