Multi conditional search

Hi team,

Please check the attached.


Sheet 1 has the user to select the option from the data base for style,size,code,bottom and top.
Sheet 2 has the data base of price list with combinations of user requirement.

What i need is
1.As the user select the combination from the dropdown list the price needs to be listed.
2.The user need not to enter all the search requirement from the drop down list even if a blank is selected then with the minimum input data all possible price data needs to be displayed.

example

If the user selects as shown below the price needs to shown as 500

style size code bottom top price
women medium 2 white yellow 500

If the user select only women+small+1+white+(no option selected) = all possible then price data needs to listed .If there is no data available then a message promt can shown as no data.

Thanks in advance

Sany

Thanks Pierre Leclerc it a good idea.But i need to do it as VB form with dropdown list for user options which filters the data from the database prompts the value .
Thanks
sany

Thanks sktneer.that really a good suggestion.
can u please provide the steps on how the macro was created.It will be a real learning ..once again thanks.

sany