Hi, i´d appreciate some help.
my main worksheet (Dados) has, among others, these 2 columns:
I wanted to automatically fill in the image when we write a value in column Fabricante, as long as that value exists in the following worksheet (Fabricantes):
So, in [Image] i´ve set this array formula:
Things work ok apparently and, in the app´s deck view, we can see the images as supposed to.
The problem occurs everytime we update a row because it is going to interfere with that formula which results in a #REF! error in the worksheet´s [Image] column and those images disappear.
I´m sure that formula is not the way to go and there must be a simple solution for experienced users like you.