0

I am building a google sheet to autogenerate a report. I have a table that populates itself but I want an image to appear at the top of the page if "IN-36" Appears in column C of "Equipment" tab. I currently have this

=ARRAYFORMULA(IF(Equipment!C6:C60="IN-36",N5,))

I have the image I want in cell N5, my issue is "IN-36" appears 21 rows down in the range described. This causes the image to appear 21 rows below the cell I place the formula in. Does anyone know how to make the image appear in the cell I have placed the formula?

Thanks for the help

=ARRAYFORMULA(IF(Equipment!C6:C60="IN-36",N5,))

Picture to appear in cell I placed the formula in

Muhammad Saqlain
  • 2,112
  • 4
  • 33
  • 48
Dan GasAnalysis
  • 1

1 Answers1

0

You may try:

=if(countif(Equipment!C6:C60,"IN-36")>0,N5,)
rockinfreakshow
  • 15,077
  • 3
  • 12
  • 19