How do I reference multiple rows
I need to create a list and reference multiple cells to a row or column in
that list, preferably using a pick list. More specifically, I have an invoice
and I want to select a specific product and have the data for that product
reference the cells following.
Item Description Price
Dropdown Reference previous selection Reference following
I want this to be done with excel, please help!
Mark
|