View Single Post
  #1   Report Post  
Awetronics
 
Posts: n/a
Default 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