You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
Thank you,

Works great. And so simple too.

Thanks again,

Steve

"T. Valko" wrote:

Try this:

=IF(COUNTIF(E4:E631,"#N/A"),"ALERT","OK")

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
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