graduateguardian
New Member
- Joined
- Feb 12, 2025
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hello.
I am trying to create a report based data in a table on another tab in Excel. I currently have my report set up with a standard VLOOKUP to change the values on the report based on a certain cell (Outfall ID). This works great however I want to be able to return the values based on a specific month as there will be monthly tracking for multiple locations. Below is what I have. I am looking for a formula that allows the data to change based on the outfall id and the month the inspection was completed.
I have tried this formula but it either pulls the data for the first entry of an outfall ID or leaves it blank. For example, I change the date from January to February looking at outfall 11-4. It will show January's data but leave February's blank even though there is data present.
=IF(AND((VLOOKUP($C$10,'Data Table'!$A:$R,2,FALSE)<=$C$8),(VLOOKUP($C$10,'Data Table'!$A:$R,2,FALSE)>=$C$7),(VLOOKUP($C$10,'Data Table'!$A:$R,1,FALSE)=$C$10)),VLOOKUP($C$10,'Data Table'!$A:$R,5,FALSE),"")
Data Tabel:
Form for output.
Also, is there a way to auto export all the data for a month (i.e. January) with a different page of the same report for all outfall ids?
Thank you in advance!!
I am trying to create a report based data in a table on another tab in Excel. I currently have my report set up with a standard VLOOKUP to change the values on the report based on a certain cell (Outfall ID). This works great however I want to be able to return the values based on a specific month as there will be monthly tracking for multiple locations. Below is what I have. I am looking for a formula that allows the data to change based on the outfall id and the month the inspection was completed.
I have tried this formula but it either pulls the data for the first entry of an outfall ID or leaves it blank. For example, I change the date from January to February looking at outfall 11-4. It will show January's data but leave February's blank even though there is data present.
=IF(AND((VLOOKUP($C$10,'Data Table'!$A:$R,2,FALSE)<=$C$8),(VLOOKUP($C$10,'Data Table'!$A:$R,2,FALSE)>=$C$7),(VLOOKUP($C$10,'Data Table'!$A:$R,1,FALSE)=$C$10)),VLOOKUP($C$10,'Data Table'!$A:$R,5,FALSE),"")
Data Tabel:
Form for output.
Also, is there a way to auto export all the data for a month (i.e. January) with a different page of the same report for all outfall ids?
Thank you in advance!!