When I create a front end tool in excel for, say, marketing folks, to use to do lookups to their spreadsheets, i tend to do a single pull down menu and then that data fills out the page of VLOOKUP formulas I've put below it.

Ok, so I've sorta mastered that part...but what I really want to do, is allow folks to do multiple pull down choices (say for example Account name, and State) and it returns a list with all other criteria (say revenue info, address info, etc).

My question(s):
1. (and yes I know this basically describes a pivot table) but is there another option?
2. How easy is this simple task in say Frontpage?

thanks in advance.
jeffrey

1) Are the marketing folks' workbooks designed as database lists? How about using ADO then? An example how to use ADO with Excel is here .

2) No idea (IMG:http://www.utteraccess.com/forum/style_emoticons/default/smile.gif)

Martin

2) Wouldn't have a clue

1) See Mr. Akyurek's sapient advice here: http://www.mrexcel.com/board2/viewtopic.php?p=154#154

I have replicated his advice in the attached WB. See A7 & B7.