Hi Forum,

How would I wrap an IF around this Array formula?

I want it to return the result of the Array formula in cases where there is a value in the cell in column E:E, but return "N/A" in cases where there is no value in the cell in column E:E.

{=MAX(IF(Sheet2!A$2:A$7=E2, Sheet2!B$2:B$7))}

Thanks very much

Dave