HI everybody ,


I am having a hard ( extremely ) time to solve the following problem , can somebody help me out ?
Consider a sheet divided in two different parts , the datas and the resume .
The datas : numbers Town Name Year
1001 A test1 97
2004 B test1 98
1785 C test2 99
3652 D test4 00
4587 E test6 01
1000 F test7 02
5624 G test3 98
1001 A test4 99

And the resume : three drop down boxes ;
Names ( test1 > test 10 )
Year ( 97 > 02 )
The State ( Alabama > Texas )

I would like to select all datas that complete the chosen criteria in the drop down boxes . Knowing that if the number is

between 1000 2000 > Minesota
2000 3000 > alabama
3000 4000 > jersey
4000 5000 california
5000 6000 florida
6000 7000 texas


Any ideas

Many thanks

David van Dea