Look for a date after a specific cell date

[Ana_H123]

Hi there, 

Can someone please help to calculate the following.

Look for the date we go OOS, and then give me the next receipt date after that date.

I currently have the following in place to look for the next receipt date, but it is not based on when we go out of stock, it is just the next date we receive stock. 

=IFERROR((INDEX($S$1:$CR$1,MATCH(CV73,S71:CR71,0))),IF(CW73<2,"CHECK","OK"))

[#2]

Hi @Ana_H123 

it's not completely clear to me what all the columns mean. If I understand correctly, the OOS date gets already calculated correctly (in column CX of your screenshot).

And you are basically searching the first (blue) row for the OOS date and pick the next date that follows this date. Is that correct?

[#3]

@Martin_Weiss 

I was able to solve this one with the following formula

=IFERROR(IF(CX13="OK","",INDEX($S$1:$CR$1,1,SMALL(IF(($S$1:$CR$1>$CX13)*($S11:$CR11>0),COLUMN($S13:$CR13)-18,""),1))),"CHECK")

Thanks for your help though