Ken,

You're assuming I know more than I do. Can you give me an example?

thanks
--
Rich D
Armstrong Custom Homes
Redmond


" wrote:

Rich

Add a column with a formula that concatenates your six criteria and
use that for you look up column.

Good luck.

Ken
Norfolk, Va


On May 22, 4:40 pm, Rich D wrote:
Hi,

In Excel 2003, I have a page where my people will put in 6 criteria; Style,
Min Sq Footage, Max Sq Footage,# Bedrooms, # Baths, Garage stalls.

I need to search thru the plans data base to list the plan numbers that
match ( or <) all 6 criteria. Can anyone please tell me how to do this?
--
Rich D
Armstrong Custom Homes
Redmond