Forum Discussion
Need help with VLOOKUP to do census data research
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?Good morning!
Please see the following attachment as requested. Sorry for the delay. It got to be a longer day at work than anticipated. In the first worksheet, I created two tables with the data I earlier noted in each row. The workbook (the second attachment) contains the worksheets in their original form (not tables), along with two Pivot tables. Initially when I was presented with this project, I was instructed to use VLOOKUP and I was given an IF(ISERROR) formula to find exact matches. I was confused with the formula to say the least.
