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