# 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:** 10
**Page:** 1
### Author:  [@gelson](https://community.glideapps.com/u/gelson)
#### Post date: [October 13, 2019, 7:20pm UTC](https://community.glideapps.com/t/display-the-latest-item-from-my-sheet/1141/1 "2019-10-13T19:20:09Z")
boa tarde
alguem conhece alguma formula para eu puxar o ultimo produto cadastrado e exibir em uma celula, conforme eu vou cadastrando ele va exibindo sempre o ultimo produto
---
### Author:  [@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")
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"))`
---
### Author:  [@gelson](https://community.glideapps.com/u/gelson)
#### Post date: [October 13, 2019, 7:49pm UTC](https://community.glideapps.com/t/display-the-latest-item-from-my-sheet/1141/3 "2019-10-13T19:49:13Z")
acho que nao entendi direito vou anexar uma imagem nela que trazer para uma celula em outra planilha sempre o ultimo produto cadastrado como mostro na foto
no caso ao inserir a formula ela teria que trazer o cubinho caso eu cadastrasse outro produto ele traria o outro
para trazer o ultimo valor eu consegui porem nao consigo trazer o ultimo produto usando a formula corresp
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 13, 2019, 8:01pm UTC](https://community.glideapps.com/t/display-the-latest-item-from-my-sheet/1141/4 "2019-10-13T20:01:21Z")
You want to return the image for CUBINHO to another sheet?
---
### Author:  [@gelson](https://community.glideapps.com/u/gelson)
#### Post date: [October 13, 2019, 8:05pm UTC](https://community.glideapps.com/t/display-the-latest-item-from-my-sheet/1141/5 "2019-10-13T20:05:26Z")
desejo que a formula traga apenas o ultimo produto cadastrado no caso sa imagem ai o cubinho
sempre assim conforme vou cadastrando ela vai mudando automaticamnete e sempre trazendo o ultimo cadastrado
o produto que falo quero apenas o nome dele mais nada apenas o nome do produto
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 13, 2019, 8:17pm UTC](https://community.glideapps.com/t/display-the-latest-item-from-my-sheet/1141/6 "2019-10-13T20:17:54Z")
Does the value (Pendente) ever change in Vendas em overto? If it does not change, I would use a formula like this:
`=ARRAYFORMULA(LOOKUP(2; 1/(RegisteredProducts!A$2:A="Pendente"); RegisteredProducts!C$2:C ))`
Change RegisteredProducts to your sheet name.
Forgive me, I’m trying to make sense with the language barrier.
---
### Author:  [@gelson](https://community.glideapps.com/u/gelson)
#### Post date: [October 13, 2019, 8:31pm UTC](https://community.glideapps.com/t/display-the-latest-item-from-my-sheet/1141/8 "2019-10-13T20:31:31Z")
IT WORKED BUT YOU USED PENDENTIAL CRITERIA AS IT CHANGES AS YOU REGISTER THE PRODUCT I CHOOSE IF THE CUSTOMER WILL SALE OPEN OR NOT AND I NEED A FORMULA WHICH WAS NOT ARRAYFORMULA
Sorry for not understanding much of FORMULAS BUT THANK YOU FOR HELP
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 13, 2019, 8:40pm UTC](https://community.glideapps.com/t/display-the-latest-item-from-my-sheet/1141/9 "2019-10-13T20:40:33Z")
So it is or is not working for you?
If you are still having issues, I will need to create a spreadsheet that explains what I’m talking about. I can maybe work on that tonight or tomorrw. The only thing I would change is to create a new column (H) in your products sheet that looks like this:
`=ARRAYFORMULA(IF(LEN(A2:A)=0; ""; "SEARCH"))`
The change this formula to look at the new column:
`=ARRAYFORMULA(LOOKUP(2; 1/(RegisteredProducts!H$2:H="SEARCH"); RegisteredProducts!C$2:C ))`
---
### Author:  [@gelson](https://community.glideapps.com/u/gelson)
#### Post date: [October 13, 2019, 8:49pm UTC](https://community.glideapps.com/t/display-the-latest-item-from-my-sheet/1141/10 "2019-10-13T20:49:01Z")
> [@Jeff\_Hager](#):
>
> =ARRAYFORMULA(LOOKUP(2; 1/(RegisteredProducts!A$2:A=“Pendente”); RegisteredProducts!C$2:C ))
WORKED I CREATED A NEW COLUMN AND I PLACE SEARCH AN ARRAYFORMULA
HOWEVER YOU CAN SEE THE IMAGE BELOW I WANTED A NORMAL FORM FOR DESCRIPTION TO APPEAR ON THE BELOW CELL
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [October 13, 2019, 9:09pm UTC](https://community.glideapps.com/t/display-the-latest-item-from-my-sheet/1141/11 "2019-10-13T21:09:26Z")
It’s a little confusing. Even though it says arrayformula, it doesn’t work like a normal arrayformula. The formula only works for the row that it is on. You just need to move it down to cell H3.
I don’t completely understand how the formula works. I just know that it does work. 😉