Lookup Function To Return Entire Table

[MountainMike]

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).

[TABLE="width: 425"]
<tbody>[TR]
[TD="colspan: 5, align: center"]Fruit [/TD]
[/TR]
[TR]
[TD="align: center"] Quantity[/TD]
[TD="align: center"] Part Number[/TD]
[TD="align: center"] Description [/TD]
[TD="align: center"]Net Price[/TD]
[TD="align: center"] Extended [/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 425"]
<tbody>[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]123[/TD]
[TD] Bananas[/TD]
[TD="align: right"]$2.00[/TD]
[TD="align: right"]$2.00[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]124[/TD]
[TD] Apples[/TD]
[TD="align: right"]$3.00[/TD]
[TD="align: right"]$6.00[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]125[/TD]
[TD] Oranges[/TD]
[TD="align: right"]$4.00[/TD]
[TD="align: right"]$12.00[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]126[/TD]
[TD] Grapes[/TD]
[TD="align: right"]$5.00[/TD]
[TD="align: right"]$20.00[/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

Welcome to the MrExcel board!

Can you show us how the fruit & vegetable data is arranged on the hidden sheet?

What is the name of the hidden sheet?