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
Bookmarks