Google Sheets

PHOTO EMBED

Mon Feb 15 2021 09:16:03 GMT+0000 (UTC)

Saved by @hazel #googleappsscript

=QUERY(planters!A:F, "select A where not F contains 'Size_' and E = 'Vase' and B <> ''")
=ArrayFormula(IF(F5:F<>"", F5:F&", Colour_White", "Colour_White"))
content_copyCOPY

google sheets