Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|