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