Hello -

I think this is a vlookup question, but it may be more than that.

On one sheet I have two columns. Column a is used for 1,2,3 ect. Column B
is a list of menu items.

I want to populate sections of a second sheet with the items from the first.
1 would be for appitizers, 2 for main course, 3 for dessert, etc. My
stumpling block is the number of items will vary.

So in summary I need to look up multiple results from a lookup.

I hope I have been detailed enough so one or more of you talented excel
people can help.

I do appreciate everyones time and effort.

Marc