Return Value from Cell if false

[Elifly]

Hey there,

I have the problem of not having my lookup function work correctly.

If there is a False Value in somewhere in the J column, it should return the value of the Cell in the G column in the same row.
But I only want the search range for dates that are the same, so I have a value for each day as a result.

I hope i described my problem somewhat understandable.

 

[jasonb75]

Is there only ever one FALSE for a given day? What should the result be if there is no FALSE or more than one FALSE?

As your results are numeric, a function like SUMIFS could possibly be a better option than VLOOKUP.

 

[Elifly]

So a bit of Background. The numbers you can see are production numbers per day.
The problem is, that sometimes the the numbers are reset. I want to visualize the numbers per day that are currently shown by MAXIF. That works pretty good right now, besides the problem, that they are not always counting and they reset somehow.
So i have a formula, that shows me the errors and all I have to do now is extract the number where the false is located and add it to the MAX of the day.

 

[jasonb75]

Sounds like you want something like

=MAXIFS(...)+SUMIFS(G:G,A:A,date,J:J,FALSE)

 

[Elifly]

Wow gee thanks, that worked out perfectly