Look Up variable starting dates by different geographies

[gmooney]

Hello,

I have a table of data that contains multiple geographies like Atlanta, Cincinnati, San Francisco, etc.....each geography can have a variable number of rows of data that relate weeks and some weeks can be repeated for the same geography.

I have a dropdown that is looking up the list of geographies and I want to display the unique weeks (actually a starting date) that is in the table for whatever geography was selected in the dropdown.

Right now I have a formula that is this:

=INDEX($C$3:$C$61000, MATCH(0, COUNTIF($BJ$2:BJ2, $C$3:$C$61000), 0))

The problem is that this only gives me the unique weeks for the entire table of C3:C61000 regardless of geography.

I need to modify that formula to account for the specific geography that I am looking for.

In this case the geographies are in column E.

Any help would be appreciated.

 

[gmooney]

Anybody out there that can help me with this?

Thanks.