Hi all! Another headscratcher for me. Excel 2003, I have a spreadsheet that contains consumer names and county names. I need to search for a particular county name and display any consumer name that is from that county on another worksheet. I know how to tell the formula what sheet and columns to search thru.

So I want this to search worksheet Consumers! for everyone from "Kane" County (C2:C100), and display their name (A2:A100), and date of birth (B2:B100), on worksheet "Kane". I do have some date strings but I think I can shoehorn that into the mix later.

Cheers!
Dan