Hello all
I’m am doing a Coronavirus Project
Let’s say I have 2 sheets
On primary sheet:
Column A Header = County
Column B Header = State
Column A is filled down with All the counties associated with California, Oregon, Washington
Column B has us the associated States to those Counties
I then sort by state.
Sheet2
Column A header =County
Column B header = State
Column C header = Total Cases
Column D header = Total Deaths
Hears the thing
I fill counties (associated with states) that only have data. Column A does not have al the counties (and its associated state) because the list I am getting only shows counties that have cases and deaths.
I want to populate the county (and state) cases and deaths on primary sheet and populate a 0 (for cases and deaths) when it does not find a county on sheet2
Hope that makes sense!