MountainMike
New Member
- Joined
- Sep 2, 2018
- Messages
- 1
Hi first time posting here, any help is much appreciated. I'm trying to create a drop down list to reorder items, the drop down selection would return 3 columns and 25+ rows from a hidden sheet. I can create the drop down, and am familiar with a vlookup but cannot get a return on the multiple rows/columns.
An example is I want to reorder produce and my list selection is Fruit & Vegetables. By selecting either Fruit or Vegetables I can bring in multiple rows with at least three columns; order number, description, and price. I will also need to have 2 additional columns, one to enter quantity and another to provide an extended price (quantity*price=extended price).
<tbody>
</tbody>
<tbody>
</tbody>
An example is I want to reorder produce and my list selection is Fruit & Vegetables. By selecting either Fruit or Vegetables I can bring in multiple rows with at least three columns; order number, description, and price. I will also need to have 2 additional columns, one to enter quantity and another to provide an extended price (quantity*price=extended price).
Fruit | ||||
Quantity | Part Number | Description | Net Price | Extended |
<tbody>
</tbody>
1 | 123 | Bananas | $2.00 | $2.00 |
2 | 124 | Apples | $3.00 | $6.00 |
3 | 125 | Oranges | $4.00 | $12.00 |
4 | 126 | Grapes | $5.00 | $20.00 |
<tbody>
</tbody>