yogi_Use DropDown List To Query Top Value For The Selected Field

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #749   Sep 15, 2012     www.energyefficientbuild.com.

user DarkXaldin said: (http://productforums.google.com/forum/?zx=rrhxx7lqsbz2#!category-topic/docs/spreadsheets/LQSDvDWqlBA)

Hi, I'm trying to have a drop down list be where you choose what query to run. Let's say that I have a table like this in another sheet:

Code        Product          Total Sales

A              A                   100

B              B                   200

C              C                   300

What I want to do is I put in a drop down list with the options in it like top seller, top product, etc., then when I choose an option, the chosen query will be run on that sheet, displaying the required data. Is this possible?

--------------------------------------------------------------------------------------------

following is a solution to a bit more generalized problem