Looking specific text in three columns at the same time

[Whoop92]

Hi Everybody!

I’ve been struggling with creating a formula for my spreadsheet. I need to look for situations where both apples and oranges are delivered by truck to the same store. Then I want to make a note of that situation on the lines with apples or oranges only.

The spreadsheet that I'll use this formula in has around 20,000 lines. I'll use the formula to manipulate the data in the lines that have the 'Apples and Oranges delivered by truck present' note.

Does anybody have an idea on how to make this work?

Thanks so much!

[humdingaling]

not entirely sure what you are trying to do
does this give you want?

Please Login or Register  to view this content.

or did you only want that statement on apples and oranges
like so

Please Login or Register  to view this content.

[JohnTopley]

In D2

=IF(AND(B2="Truck",OR(C2="Apples",C2="Oranges")),IF(COUNTIFS(A:A,A2,B:B,B2,C:C,"Apples")=COUNTIFS(A:A,A2,B:B,B2,C:C,"Oranges"),"Together",""),"")

[Whoop92]

Awesome! Thanks Humdingaling and JohnTopley! Both those formulas worked!

(I tried to give both of you reputation but it wouldn't let me give it to John...so sorry.)