Name a cell range and insert a column.

Display the Lookup$\_$Data worksheet.

Select cells A$2$:A$6$ and name the range City, and select cells B$2$:B$6$ and name the range TaxRates.

Display the TransactionData worksheet and insert a column before column C$.$

Select cell C$5$ and type Tax Rate

Build a XLOOKUP formula.

Select cell C$6$ on the TransactionData tab.

Build a XLOOKUP formula to lookup the value in cell A$6$ in the City range and display the tax rate.

Copy the XLOOKUP formula in column C and format the results as Percent Style with $2$ decimals.

Write a formula to calculate the amount of the sales ticket with tax.

Select cell D$6$ on the TransactionData tab.