View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
 
Posts: 1,549
Default How do I get a popup window on a VLOOKUP lookup failure?


=IF(ISERROR(AVERAGE(C5:H1000)),"PROBLEM","OK")
Note: the range being verified must contain at least one numeric value.
--
Jim Cone
Portland, Oregon USA .
http://www.mediafire.com/PrimitiveSoftware .
(free and commercial excel programs)



"Mark F"
wrote in message
...
Doesn't do what I want: I want ANY error to show up in some fixed
location.

There will be 1000s of cells.
"Mark F"