"Please advise on how to correctly input the formulas to get the desired result as shown in the picture. Task:
- Лист1 (used as a database) where information is entered and then distributed to ЯБЛОКИ,ГРУШИ,СЛИВЫ.
- On Sheets (ЯБЛОКИ,ГРУШИ,СЛИВЫ) I applied the ARRAYFORMULA function to import images from the "PNG" sheet, but the import formula from Лист1 was immediately disrupted. Here is the desired version on the "ГЛАВНЫЙ" sheet."