Need help in database in excel

[cakjsingh2011]

I have a spreadsheet with following columns -
User ID
Age
Height
Body type
Complexion
Diet
many other like this

I want to create a database such that, For E.g. if someone selects age between 23 to 26 and height 5.6 to 5.9, body type as average, then it should pick all filtered data (as per criteria) on main sheet. Plz advice how can i do it? Applying vlookup or hlookup is not sufficient. I need something advanced.
Please reply ASAP.

 

[cakjsingh2011]

Its really very urgent. Please reply ASAP

 

[look]

Hi cakjsingh2011,

Creat list

1 Need header

2 No empty rows

3 each item in separate colum

4 Use data filter

Thanks