Using VLookUp

[nofishing]

Hi, I'm currently trying to create a system whereby a user can make queries in excel much like they could in access.
I've got a small database of houses in Excel, and I have the following criteria that I'd like to be able to input and for Excel to find houses which match all criteria.

<table x:str="" style="border-collapse: collapse; width: 398px; height: 243px;" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" span="2" width="64"> <col style="width: 111pt;" width="148"> <col style="width: 102pt;" width="136"> <tbody><tr style="height: 27pt;" height="36"> <td class="xl23" colspan="4" style="height: 27pt; width: 309pt;" width="412" height="36">Advanced House Search</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 22.5pt;" height="30"> <td class="xl22" colspan="3" style="height: 22.5pt;" height="30">Maximum Price:</td> <td class="xl24" x:num="795000" align="right">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 22.5pt;" height="30"> <td class="xl22" colspan="3" style="height: 22.5pt;" height="30">Minimum No. Beds:</td> <td x:num="" align="right">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 22.5pt;" height="30"> <td class="xl22" colspan="3" style="height: 22.5pt;" height="30">Minimum No. Baths:</td> <td>
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td>
</td> <td>
</td> <td>
</td> </tr> <tr style="height: 22.5pt;" height="30"> <td class="xl22" colspan="3" style="height: 22.5pt;" height="30">Minimum No. Receptions:</td> <td>


</td> </tr> </tbody></table>
I would like the houses that match all of the criteria to appear on another page too. How is this possible? I need to be able to link the VLookUps for each of the different criteria, and then somehow make this appear on another page? I thought maybe inputting the formula into a cell on another page and then after all of the criteria have been input having a button saying 'search' or something similar which simply links to the second page? Thanks for your help in advance!

 

[stanleydgromjr]

nofishing,

Welcome to the MrExcel board.

Data, Filter, AdvancedFilter with cirteria and extract ranges is one solution.

This may help you get started in the right direction.

See post #4:
http://www.excelforum.com/excel-worksheet-functions/668715-one-criteria-return-multiple-records.html


Have a great day,
Stan

 

[Muralikrishnan]

Can u please send a spreadsheet sample to my email address. I can help you in this regard.

 

[nofishing]

Hi I've worked out I can do this using a macro, so i go to record macro, go to the database page, and then on the autosort drop down menu choose custom, and then change it to greater than or equal to, but how is it possible to put the contents of a cell automatically into the box if you get me?