Select cell G$2.$ Notice that data in column E is sorted by type so that daily rates are first, followed by monthly, and then weekly.

Start the XLOOKUP function with cell B$2$ as the Lookup$\_$value argument.

The Lookup$\_$array is the Equipment$\_$ID range.

The Return$\_$array is the Daily$\_$Rental range. The result for cell G$2$ is $250($Figure $2-122).$

XLOOKUP to display the rate

Figure $2-122$ XLOOKUP to display the rate

Copy the formula in cell G$2$ to cells G$3$:G$35.$ You will edit the formula in cell G$35$ to display the monthly rate.

Select cell G$35$ and click the Insert Function button in the Formula bar to open the Function Arguments dialog box.

Edit the Return$\_$array to display the Monthly$\_$Rental range. $($If you used VLOOKUP, edit the Col$\_$index$\_$num range to $6$ because the monthly rates are in the sixth column of the table$\_$array.$)$

Copy the formula in cell G$35$ to cell G$36$:G$37.$

Select cell G$37$ and edit the formula to display the Weekly$\_$Rental range. $($In a VLOOKUP formula, the Col$\_$index$\_$num range is $5$ for the weekly rate.$)$

Copy the formula in cell G$37$ to complete the column.