# Imagem **URL:** \ **Category:** Ask for Help\ **Created:** [October 14, 2019, 12:06am UTC](https://community.glideapps.com/t/imagem/1148 "2019-10-14T00:06:56Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![gelson](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@gelson](https://community.glideapps.com/u/gelson)\ **Post date:** [October 14, 2019, 12:06am UTC](https://community.glideapps.com/t/imagem/1148/1 "2019-10-14T00:06:56Z")
boa noite gostaria que alguem pudesse me ajudar em uma arrayformula 1.tenho varias vendas com os status (pendente e confirmado) 2.queria exibir uma imagem para cada tipo de status isso e possivel 3.tenho uma planilha onde fica os status la eu posso criar uma coluna imagem e colocar uma imagem para cada tipo de status porem nao sei como puxar ela para a planilha pedidos ---
**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 14, 2019, 12:42am UTC](https://community.glideapps.com/t/imagem/1148/2 "2019-10-14T00:42:42Z")
Method 1 (A2:2 is the status): `=ARRAYFORMULA(IF(LEN(A2:A)=0; ""; IF(A2:A="confirmado"; "ConfirmadoImageURL"; "PendenteImageURL")))` Method 2 (B2:B is the Status. Images!A3:B is the sheet and columns to search where A is the status and B is the image URL. The 2 says to return the second column, which is B): `=arrayformula(IF(LEN(A2:A) = 0, "", VLOOKUP(B2:B, Images!A3:B, 2, false)))` ---
**Author:** ![gelson](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@gelson](https://community.glideapps.com/u/gelson)\ **Post date:** [October 14, 2019, 12:59am UTC](https://community.glideapps.com/t/imagem/1148/3 "2019-10-14T00:59:09Z")
> [@Jeff\_Hager](#): > > =ARRAYFORMULA(IF(LEN(A2:A)=0; “”; IF(A2:A=“confirmado”; “ConfirmadoImageURL”; “PendenteImageURL”))) usei a primeira coloquei uma imagem quando fosse confirmado e uma imagem quando estivesse pendente porem tanto pendente como confirmado aparece a mesma imagem ?? sera que fiz algo errado ---
**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 14, 2019, 1:27am UTC](https://community.glideapps.com/t/imagem/1148/4 "2019-10-14T01:27:32Z")
![Capture](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/88b99f9a4caab4be79e88a14dd22dd5fed6fc68d.jpeg) Make sure the highlighted parts are the column that contains the status and the value that you have in that column. I’m not sure how you are spelling “confirmed”. It’s most likely resulting in the FALSE portion of the IF statement because it’s not resulting in TRUE when the status is confirmed. ---
**Author:** ![gelson](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@gelson](https://community.glideapps.com/u/gelson)\ **Post date:** [October 14, 2019, 1:29am UTC](https://community.glideapps.com/t/imagem/1148/5 "2019-10-14T01:29:39Z")
> [@Jeff\_Hager](#): > > =ARRAYFORMULA(IF(LEN(A2:A)=0; “”; IF(A2:A=“confirmado”; “ConfirmadoImageURL”; “PendenteImageURL”))) ![cc](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/646875acc583bc6e419e29a54f8f350bebe0e03d.png) ---
**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 14, 2019, 1:31am UTC](https://community.glideapps.com/t/imagem/1148/6 "2019-10-14T01:31:51Z")
Change A2:A to B2:B. That’s where you have your Pending and Confirmed values. ---
**Author:** ![gelson](https://avatars.discourse-cdn.com/v4/letter/g/eb9ed0/32.png) [@gelson](https://community.glideapps.com/u/gelson)\ **Post date:** [October 14, 2019, 1:44am UTC](https://community.glideapps.com/t/imagem/1148/7 "2019-10-14T01:44:48Z")
quero agradecer voce pela ajuda muito obrigado nao entendo muito de formulas mas com sua ajuda estou aprendendo ![certo](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/c947031360ed3fe19a77fb4f312be5bdfba27af5.png) ---
**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 14, 2019, 1:53am UTC](https://community.glideapps.com/t/imagem/1148/8 "2019-10-14T01:53:58Z")
Thank you for providing screenshots. That really helps a lot.