Hi All

Just wondering if a drop box in excel can have a formula?

For example I want my dropbox to have a list of buyers i.e ASD, FDF, GSD

If I click ASD i would like the answer to use a formula to find out the volume they bought from a different spread sheet.

Is this possible please?