Need help with VLOOKUP to do census data research

mathetes 

Good morning,

Per your request, the following are the row designations for worksheet one and worksheet two of the overall workbook.

Worksheet One rows:

Row 1: Transaction Agreement Date

Row 2: Transaction Amount

Row 3: Transaction City

Row 4: Zip code

Row 5: Zipco (this is the row that will need to be used to link the data from worksheet one to worksheet two)

Row Six: Year (2019)

Count: 1 per zip code designation

Worksheet Two rows:

Row 1: Zip code Tabulation Area (Zip codes)

Row 2: Total Population per zip code

Row 3:  Estimated Population NOT Hispanic or Latino

Row 4: Estimated Population NOT Hispanic or Latino (White Alone)

Row 5: Estimated Population NOT Hispanic or Latino (AA/ Black Alone)

Row 6: Estimated Population Hispanic or Latino

Any insight is greatly appreciated!