Look up from spreadsheet based on 6 criteria
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
|