# Live Audience Poll **URL:** \ **Category:** Feature Requests\ **Created:** [October 15, 2019, 8:35pm UTC](https://community.glideapps.com/t/live-audience-poll/1202 "2019-10-15T20:35:19Z")\ **Posts on this page:** 1\ **Showing post:** 23
**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:** [November 11, 2019, 11:56pm UTC](https://community.glideapps.com/t/live-audience-poll/1202/23 "2019-11-11T23:56:33Z")
Not even going to attempt to wrap my head around that formula. It’s easier for me to understand something when I can apply it to my own situation. I just wanted to offer some additional information. Doesn’t quite apply to your situation, but it’s a good formula to keep in the back of your mind. The attached thread shows how to find the last record that matches a search term. It’s good if you just need to find that last submission for a particular user, but not as useful for a poll. > [@Display the latest item from my sheet](https://community.glideapps.com/t/display-the-latest-item-from-my-sheet/1141/2): > > Yes, this formula returns the last item that matches a search value: =IF(ISERROR(ARRAYFORMULA(LOOKUP(2, 1/(PhotoChoiceResponses!A$2:A=A3), PhotoChoiceResponses!B$2:B))), "", ARRAYFORMULA(LOOKUP(2, 1/(PhotoChoiceResponses!A$2:A=A3), PhotoChoiceResponses!B$2:B))) This is what I use in the Photo Choice example in [https://concepts.glideapp.io/](https://concepts.glideapp.io/) Here is a simplified version with the conversion from ( , ) to ( ; ) for you: =ARRAYFORMULA(LOOKUP(2; 1/(FormResponseSheet!A$2:A=A3); FormResponseSheet!B… --- _[View the full topic](https://community.glideapps.com/t/live-audience-poll/1202)._