# Index Match Array Formula

**URL:** <https://community.glideapps.com/t/index-match-array-formula/2513>\
**Category:** Ask for Help\
**Created:** [November 29, 2019, 3:40pm UTC](https://community.glideapps.com/t/index-match-array-formula/2513 "2019-11-29T15:40:32Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Claire](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/claire/32/1512_2.png) [@Claire](https://community.glideapps.com/u/Claire)\
**Post date:** [November 29, 2019, 3:40pm UTC](https://community.glideapps.com/t/index-match-array-formula/2513/1 "2019-11-29T15:40:32Z")

</div>

I have a calendar app to help schedule jobs and record how long they take to do and users can add jobs on the app. When someone starts/finishes a job, I take their email address, and current date and time from a separate tab. I then have an index,match function which will match their address and time with the job on the calendar tab. How can I make the index match, copy down on the calendar tab for when new jobs are added from the app. I have tried using an array formula, however won’t work with the index match combination.

---

<div class="post-metadata">

**Author:** ![Karim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/karim/32/13974_2.png) [@Karim](https://community.glideapps.com/u/Karim)\
**Post date:** [November 29, 2019, 4:25pm UTC](https://community.glideapps.com/t/index-match-array-formula/2513/2 "2019-11-29T16:25:50Z")

</div>

Hi Claire  
Your best bet is to use the =QUERY() formula.  
I’m not an expert of QUERY but this resource has helped me a lot:

[https://www.benlcollins.com/spreadsheets/google-sheets-query-sql/](https://www.benlcollins.com/spreadsheets/google-sheets-query-sql/)

---

<div class="post-metadata">

**Author:** ![Les\_Henderson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/les_henderson/32/1142_2.png) [@Les\_Henderson](https://community.glideapps.com/u/Les_Henderson)\
**Post date:** [November 29, 2019, 8:02pm UTC](https://community.glideapps.com/t/index-match-array-formula/2513/3 "2019-11-29T20:02:20Z")

</div>

Very nice tutorials. Sadly I’m still a sheet noob who can only visualize basic sheets of raw data.

So, I’m still left wondering how you position the query results in a sheet so that Glide pulls just that filtered info in without all the other base data.

---

<div class="post-metadata">

**Author:** ![Karim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/karim/32/13974_2.png) [@Karim](https://community.glideapps.com/u/Karim)\
**Post date:** [November 30, 2019, 12:30am UTC](https://community.glideapps.com/t/index-match-array-formula/2513/4 "2019-11-30T00:30:44Z")

</div>

Hi Les,  
The best practice when using data consolidation (filtering, summing etc… data) is to have 1 tab with all your raw data, call it Database for example.  
And one tab with the formulas that only show the data you need, call it whatever you want.  
This way on Glide you can chose only to display the one tab with data consolidation.

---

<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:** [December 4, 2019, 5:23am UTC](https://community.glideapps.com/t/index-match-array-formula/2513/5 "2019-12-04T05:23:11Z")

</div>

@Claire Do you have any screenshots or a sample of your sheet? I’m having trouble picturing what you are trying to do. I’m wondering if there is a better way to do this instead of an index/match.