I have a google sheets doc. on the sheet TEST in cell E28 I need it to search the sheet "DisplayShare/Zone Data" and bring up all the values from that sheet that show as #N/A. I have similiar formulas on the TEST sheet which use an ARRAYFORMULA
Solved by G. L. in 21 mins