# ARRAYFORMULA, VLOOKUP, QUERY and AND together

**URL:** <https://community.glideapps.com/t/arrayformula-vlookup-query-and-and-together/62057>\
**Category:** Ask for Help\
**Created:** [May 23, 2023, 5:58pm UTC](https://community.glideapps.com/t/arrayformula-vlookup-query-and-and-together/62057 "2023-05-23T17:58:43Z")\
**Posts on this page:** 1\
**Showing post:** 7

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [May 24, 2023, 3:02am UTC](https://community.glideapps.com/t/arrayformula-vlookup-query-and-and-together/62057/7 "2023-05-24T03:02:40Z")

</div>

> [@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?

> [@litter\_in\_bin\_sign Trash your Excel Formulas](https://community.glideapps.com/t/trash-your-excel-formulas/55788):
>
> wave 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 upside_down_facepopcorn Enjoy! [[Glide: Replace 14 Excel Formulas with Glide Computed Columns] ](https://www.youtube.com/watch?v=YITKadLUKNE)

---

_[View the full topic](https://community.glideapps.com/t/arrayformula-vlookup-query-and-and-together/62057)._