How to fill a range with data from another range?

[Guest]

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

 

[Anne Troy]

A simple VLOOKUP, Themis. Try this:
http://www.officearticles.com/excel/vlookup_formulas_in_microsoft_excel.htm
And perhaps something like this will help you as well:
http://www.officearticles.com/tutorials/order_form_or_invoice_form_in_microsoft_excel.htm
************
Anne Troy
www.OfficeArticles.com

 

[Guest]

Hello Anne,

Thank you so much for your quick reply! This seems to sum it up quite
nicely, I think it will work... Thanks again!

Th

 

[Anne Troy]

Terrific!
************
Anne Troy
www.OfficeArticles.com

 

[Guest]

Indeed! These discussion groups have always proved so helpful for me, with so
great people REALLY providing help!

Cheers
Th