# Display the latest item from my sheet

**URL:** <https://community.glideapps.com/t/display-the-latest-item-from-my-sheet/1141>\
**Category:** Ask for Help\
**Created:** [October 13, 2019, 7:20pm UTC](https://community.glideapps.com/t/display-the-latest-item-from-my-sheet/1141 "2019-10-13T19:20:09Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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:** [October 13, 2019, 7:44pm UTC](https://community.glideapps.com/t/display-the-latest-item-from-my-sheet/1141/2 "2019-10-13T19:44:47Z")

</div>

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$2:B))`

If you are not looking for a specific matching value and want the last record only, then `=INDEX(A:A,COUNTA(A:A),1)` is an option, but it only works if there are no empty cells in a column. You can still use my first suggestion, if you create a column in your sheet with a value that is the same for all form responses. Then the formula can search for that specific value. `=ARRAYFORMULA(LOOKUP(2; 1/(FormResponseSheet!A$2:A=A3); "Search Value"))`

---

_[View the full topic](https://community.glideapps.com/t/display-the-latest-item-from-my-sheet/1141)._