ARRAYFORMULA, VLOOKUP, QUERY and AND together

[Robert_Petitto]

@ThinhDinh

Also, have you considered moving this logic to a Glide calculated column, or do you need to see it in the Sheets?

This

Maybe this will help?

Trash your Excel Formulas

Hey Gliders! By request, I created a video that explains how to replace 14 commonly used Google Sheet/Excel Formulas using Glide computed columns and other native Glide functionality. Formulas are timestamped in the description. For good measure, I also threw in how to use the Excel Formula plugin column Enjoy! [Glide: Replace 14 Excel Formulas with Glide Computed Columns]