Hi,
I am working on a project where I am trying to automatically filter data from one sheet and auto populate it in another workbook.
There are two spreadsheets: one contains budget information for many different properties and the other one is basically a form that I am using to pull data together from various spreadsheets. I have been able to get away with using the VLOOKUP function for a lot of this project, but it doesn't work with the budget sheet because there are many rows of data that could be pulled over based on the referenced cell.
Here is what the budget sheet looks like:
CITY STATE LEASE # FY2015sqft FY2015 Parking Space FY2015 rent
Buffalo NY 111111 25000 25 5000000
Buffalo NY 222222 23400 34 6000000
Washington DC ....................... .............................. ..............
I need to pull data pertaining to a particular city over to the new excel spreadsheet. I.E. I want the Buffalo NY rows to auto populate into the new sheet without any other city information for Washington DC and other cities.
As you can see, VLOOKUP won't work because there is different data amongst the various rows of Buffalo data.
I did some research and found that I have to use the index, row, and match formulas together, but I am having a hard time making sense of how to nest all of them together.
When you get a chance, let me know if you can figure this out! Thank you, I definitely appreciate your help.
Kevin
I am working on a project where I am trying to automatically filter data from one sheet and auto populate it in another workbook.
There are two spreadsheets: one contains budget information for many different properties and the other one is basically a form that I am using to pull data together from various spreadsheets. I have been able to get away with using the VLOOKUP function for a lot of this project, but it doesn't work with the budget sheet because there are many rows of data that could be pulled over based on the referenced cell.
Here is what the budget sheet looks like:
CITY STATE LEASE # FY2015sqft FY2015 Parking Space FY2015 rent
Buffalo NY 111111 25000 25 5000000
Buffalo NY 222222 23400 34 6000000
Washington DC ....................... .............................. ..............
I need to pull data pertaining to a particular city over to the new excel spreadsheet. I.E. I want the Buffalo NY rows to auto populate into the new sheet without any other city information for Washington DC and other cities.
As you can see, VLOOKUP won't work because there is different data amongst the various rows of Buffalo data.
I did some research and found that I have to use the index, row, and match formulas together, but I am having a hard time making sense of how to nest all of them together.
When you get a chance, let me know if you can figure this out! Thank you, I definitely appreciate your help.
Kevin