In cell G6, use the appropriate lookup and reference function to retrieve the rental rate from the named range RentalRates. The

Question

Nataly [62]

2 years ago

15

In cell G6, use the appropriate lookup and reference function to retrieve the rental rate from the named range RentalRates. The

function should look for an exact matching value from column A in the data.

Computers and Technology

1 answer:

lora16 [44] · Answer 1 · 2022-06-07T07:14:27+03:00

=VLOOKUP($A6,RentalRates,2,0) is the lookup for this.

<u>Explanation:</u>

Utilize the LOOKUP capacity to look into an incentive in a one-section or one-push go, and recover an incentive from a similar situation in another segment or one-push go. The query work has two structures, vector and cluster. This article depicts the vector structure.

In computer science, a lookup table is a cluster that replaces run time calculation with a more straightforward exhibit ordering activity. The investment funds as far as handling time can be critical, since recovering an incentive from memory is regularly quicker than experiencing a "costly" calculation or information/yield activity.