match multiple criteria and highlight corresponding row in Excel
 

I have a spreadsheet with information across rows (about 25 columns worth).
Column "A" contains a Street Number and column "B" contains a street name.
The rest of the information across the row (Columns "C" through "Y") contains
other information about each property. I would like to be able to enter a
Street Number (column A) and a Street Name (Column B), have Excel search the
data base and find and go to the row that both the Street Number and Street
Name match.

With the example below, If I enter "6" in a cell and "Park Ave" in another
cell, go to, and highlight Row 2 (by highlight I mean as if you placed the
cursor on the "2" column number and clicked, highlighting the entire row.) Or
just go column "A" Row 2.

A B C D
E Etc.....
St. Number St. Name Type Dwelling Year Built Sq. Footage
1 2 Park Ave Colonial 1998
2800
2 6 Park Ave Ranch 1990
1558
3 10 Park Ave Colonial 1856
2240
4 2 First St. Cape 1960
1800
5 6 First Ave Ranch 1960
1456

match multiple criteria and highlight corresponding row in Excel
 

Have you considered using AutoFilter? It seems like it would do exactly what
you want.

If you're unfamiliar with AutoFilter, check Debra Dalgleish's excellent
website:

http://www.contextures.com/xlautofilter01.html

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"D Assess" wrote:

I have a spreadsheet with information across rows (about 25 columns worth).
Column "A" contains a Street Number and column "B" contains a street name.
The rest of the information across the row (Columns "C" through "Y") contains
other information about each property. I would like to be able to enter a
Street Number (column A) and a Street Name (Column B), have Excel search the
data base and find and go to the row that both the Street Number and Street
Name match.

With the example below, If I enter "6" in a cell and "Park Ave" in another
cell, go to, and highlight Row 2 (by highlight I mean as if you placed the
cursor on the "2" column number and clicked, highlighting the entire row.) Or
just go column "A" Row 2.

A B C D
E Etc.....
St. Number St. Name Type Dwelling Year Built Sq. Footage
1 2 Park Ave Colonial 1998
2800
2 6 Park Ave Ranch 1990
1558
3 10 Park Ave Colonial 1856
2240
4 2 First St. Cape 1960
1800
5 6 First Ave Ranch 1960
1456