Hello people!

I hope someone could help me - I think what I need is not very complex, but
I can't figure it out for the life of it!

I have a list of customers and each of them gets a specific kind of discount
for each product category (so in effect I've got a table, say 50 rows down by
10 columns accross).

What I need to do is, on a different sheet, to be able to have a dropdown
list with the customer names (I know how to do this), and when I choose a
customer from the list a table nearby will be filled with the discount values
from the aforementioned sheet.

Anyone can tell me of a simple way to do this? Do I need to go pivot-y?

Thank you in advance :)
Th