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

You may want to check out dependant dropdown menu, go to contextures web
sight and check it out

http://www.contextures.com/xlDataVal13.html


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=528874