Fred,
The plans db is in Excel also. The columns are labelled the same and the
criteria needs to either match exactly in some cases or be <= or + in some
cases, depending on which column I'm comparing to (looking in). This would
be much simpler if I could just email you the file. thanks for any help.
--
Rich D
Armstrong Custom Homes
Redmond


"Fred Smith" wrote:

You're assuming we know as much as you do. What does the "plans data base"
look like? Is it in Excel? Are the six criteria all in one cell, or separate
cells? Does each criteria match exactly, or do you, for example, want to
match 2.5 baths to 2 baths?

Regards,
Fred.

"Rich D" wrote in message
...
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