Lookup Multiple Rows and Return Yes or No

Hi,

Try this calculated column formula

=IF(CALCULATE(COUNTROWS(Data),FILTER(Data,Data[container_nr]=EARLIER(Data[container_nr])&&Data[Status]="Completed"))>=1,"Yes","No")

Hope this helps.

Are there multiple tables involved here? The example I put together was for everything in a single table and it seemed like it was returning the correct status.

good day  Greg,

here is what i did: I took a beer, had a good rest, tried it again and found out it is woking fine.

Thank you so much!

john