=VLOOKUP(B2, Inventory!$A$2:$F$17,4,FALSE)).
a. Select cell G2. Notice that data in column E is sorted by type so that daily rates are first,
followed by monthly, and then weekly.
b. Start the XLOOKUP function with cell B2 as the Lookup_value argument.
c. The Lookup_array is the Equipment_ID range.
d. The Return_array is the Daily_Rental range. The result for cell G2 is 250 (Figure 2-122).
vix fx-XLOOKUP(82.Equipment_ID,Daily Rental)
D
