Data update: If, and, vlookup functions

Status
Not open for further replies.

graduateguardian

New Member
Joined
Feb 12, 2025
Messages
3
Office Version
  1. 365
Platform
  1. 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:

1739373626037-png.122284




Form for output.

1739368206670.png



1739373735421-png.122285




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!!
 
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.
 
Upvote 0
Status
Not open for further replies.

Forum statistics

Threads
1,226,771
Messages
6,192,917
Members
453,766
Latest member
Gskier

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top