Q:

Pulling cell text based on multiple criteria

Spreadsheet
In trying to add ingredients from the data page if the "need it!" drop down is selected and no "got it!" options are selected in the category ie: beans, fruit,... 
the best i am able to do s select all "need it!" with   
=QUERY(Data!$A$2:$C, "select A where C='Need It!'", 1)

but i don't want the categories that contain "got it" so the only result im looking for is chicken eggs.

A:

Can you check if this (rather convoluted) formula works ?
=iferror(query(ArrayFormula({filter(Data!A2:A, Data!C2:C="Need It!"), isna(match(filter(Data!B2:B, Data!C2:C="Need It!")&"Got It!", query(Data!B2:B&Data!C2:C, "select* where Col1 contains 'Got It!' "), 0))}), "select Col1 where Col2 =TRUE "))

