Forum Discussion
Need help with VLOOKUP to do census data research
Hi All! I am trying to do a VLOOKUP using two tables to determine two outcomes: a) number and amount of payday loans per person in each ZCTA (Zipcode tabulation Area) for a specific year B) number of loans per person in the ten ZCTAs with the highest percentage of a certain population group in 2020. I am very new to using VLOOKUP and I am hav
5 Replies
- Your question as posted here is incomplete, too much so for anybody to give a meaningful answer. If you still would like help, come back and post a far more complete description.
What do the two tables look like (how are they organized, what data columns are there)
What version of Excel are you working with? It's entirely possible that something other than VLOOKUP would be a better solution, including some of the newest functions like FILTER, but they require the newest versions of Excel.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!
- Given that way of organizing your data (records in columns rather than in rows) you'd need HLOOKUP rather than VLOOKUP.
But better would be to use Transpose to change the arrangement of the data, so that VLOOKUP could work. And it's just a more "normal" way to view records of data.
That said, is it possible for you to attach either the actual worksheets, or some scaled down representations of them (as Excel sheets, not just images), so that I or somebody else could work with the actual data?
