Hello,
I could not think of the search terms to find what I am looking for but ideally you can lend me a hand. I have multiple cities and I am trying to pull data from a large CSV table and I have two pictures attached.
• Summary is my result sheet that is a weekly rolling update
• CSV is a large file that builds from 2009 to current date
I need to use function to match the city, then if true, match the date with a lookup and populate the proper column.
Ex.
1) B1 = Philadelphia, PA, G1 = New York, NY
2) Then I need to pull the CSV data to match the date of May 20th to the exact cities event. I have both shown below with dummy data
a. I can do this with a normal VLOOKUP by sorting the CSV data and then updating the formula, but I would rather not do this as this data table will continue to grow and more cities will be added on an as needed basis
If anything else is needed please let me know, thanks for your time.
Summary
CSV Data
I could not think of the search terms to find what I am looking for but ideally you can lend me a hand. I have multiple cities and I am trying to pull data from a large CSV table and I have two pictures attached.
• Summary is my result sheet that is a weekly rolling update
• CSV is a large file that builds from 2009 to current date
I need to use function to match the city, then if true, match the date with a lookup and populate the proper column.
Ex.
1) B1 = Philadelphia, PA, G1 = New York, NY
2) Then I need to pull the CSV data to match the date of May 20th to the exact cities event. I have both shown below with dummy data
a. I can do this with a normal VLOOKUP by sorting the CSV data and then updating the formula, but I would rather not do this as this data table will continue to grow and more cities will be added on an as needed basis
If anything else is needed please let me know, thanks for your time.
Summary
CSV Data
