IF #N/A ( in a range), "ALERT","OK"

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
 
S

Steve

Can't quite get it to work yet, probably because of the ranges, which I'll
check out. I'm sure it'll work when I play around with it. But the other
suggestion is working, and that's one of the great things about Excel, more
than one way to achieve what you're looking for.

Thanks again,

Steve
 
B

Bam

Steve,

Sorry, I mis-read the question a bit.

=IF(ISERROR(E4:E631),"Alert","OK")

Put this in G2.

Cheers,

Bam.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top