I’m keeping a spreadsheet in order to keep track of who rents what as the owner of a (very small) rental business (stemmed from my love of costumes and collection I’ve accumulated over the years!). I have a data table set up with the rental costume’s description and the rate that it’s loaned at.

For example:

Rennaissance Velvet Dress | 98 |
(name, sku, rental rate)

I then keep a list of customers at the bottom with the pertinent information next to their names.

Is there any way I could link the data?

For example:

I put in the name, link sku number to the cell next to it in the data table, and have a formula set up to reference that item’s rental rate down by the customer’s name? (Argh; trying to explain this is difficult)

For example.

I type in John’s name as my customer. I then hit, in the next cell, "=(click cell with sku number)." In the cell after that, it pops up the rate, and then in the cell after that the item description. So with a keyboard tap and a click it would pop up as:

John | 98 | Renaissance Velvet Dress | ?

Please help!