match multiple criteria and highlight corresponding row in Excel

D

D Assess

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top