Data update: If, and, vlookup functions

[graduateguardian]

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!!

 

[Fluff]

Duplicate to: If, And, VLOOKUP Nesting Help

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.