# How to use arrayformula with Query

**URL:** https://community.glideapps.com/t/how-to-use-arrayformula-with-query/3851
**Category:** Ask for Help
**Created:** [January 22, 2020, 7:50am UTC](https://community.glideapps.com/t/how-to-use-arrayformula-with-query/3851 "2020-01-22T07:50:54Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Bhupendra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bhupendra/32/788_2.png) [@Bhupendra](https://community.glideapps.com/u/Bhupendra)
#### Post date: [January 22, 2020, 7:50am UTC](https://community.glideapps.com/t/how-to-use-arrayformula-with-query/3851/1 "2020-01-22T07:50:54Z")

</div>

I want to use Query with Arrayformula

### =QUERY(Result!A2:K,“select E where (B=”&B2&" and D=“&C2&”)")

 ![2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/1601087e4176a54c690982dd174c67755985871a.jpeg)

Any help please.

---

<div class="post-metadata">

### Author: ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)
#### Post date: [January 22, 2020, 8:00am UTC](https://community.glideapps.com/t/how-to-use-arrayformula-with-query/3851/2 "2020-01-22T08:00:05Z")

</div>

QUERY is not supported by GSheet with ARRAYFORMULA.

BUT, I think you’ll find help here (or on other sites/forums ) :

> <https://webapps.stackexchange.com/questions/97310/how-to-use-arrayformula-with-query-in-google-sheets>

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [January 25, 2020, 1:18am UTC](https://community.glideapps.com/t/how-to-use-arrayformula-with-query/3851/3 "2020-01-25T01:18:02Z")

</div>

One thing I’ve done is create another sheet and use a query or a simple formula like `={Result!A:K}` to fill it with duplicate data from the original sheet. Then in the next available column I add the query formula and drag it down 1000 or 2000 rows. `=QUERY(Result!A$2:K,“select E where (B=”&B2&" and D="&C2&")")`. You can either use the new sheet in the app, or put a formula in column L or the original sheet and use the formula `={NewResultSheet!L:L}` to populate the data in query results in the original sheet.

---

<div class="post-metadata">

### Author: ![Mauronic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mauronic/32/21726_2.png) [@Mauronic](https://community.glideapps.com/u/Mauronic)
#### Post date: [January 15, 2021, 4:45pm UTC](https://community.glideapps.com/t/how-to-use-arrayformula-with-query/3851/4 "2021-01-15T16:45:46Z")

</div>

Part of the puzzle I needed to bundle related items in a sheet. Thanks @Jeff_Hager