S
Steve
I have a rang of cells with formulas in them as below:
=VLOOKUP(Data!A4,Table!$A$1:$A$101,1,FALSE).
This formula produces either numbers or #N/As in the below range:
The range is from E4 through E631.
If any of the cells ( E4:E631) have #N/A in them, I would like "ALERT" to
show Cell G2, if no #N/A, then "OK" in cell G2.
Something like If (E4:E62 contains #N/A, "Alert", "OK")
So I don't have to scroll down looking for #N/A 's that may or may not be
there.
Thanks,
Steve
=VLOOKUP(Data!A4,Table!$A$1:$A$101,1,FALSE).
This formula produces either numbers or #N/As in the below range:
The range is from E4 through E631.
If any of the cells ( E4:E631) have #N/A in them, I would like "ALERT" to
show Cell G2, if no #N/A, then "OK" in cell G2.
Something like If (E4:E62 contains #N/A, "Alert", "OK")
So I don't have to scroll down looking for #N/A 's that may or may not be
there.
Thanks,
Steve