use 2 input cells to return rows from another sheet

[Jane Fischer]

I am wondering if it is possible to use 2 cells to input values and then do a lookup to another sheet based off the 2 values and return any rows that contain those 2 values.

 

[Gary McMaster]

You should be able to create a "Parameter Query" of your second sheet and pass the parameters from specified cells on the primary sheet. There are some tutorials here:

http://www.tushar-mehta.com/excel/newsgroups/rdbms_in_excel/index.html

Hope they help.

Gary

 

[Jane Fischer]

Thank you for the help Gary.