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

I am using the VLOOKUP function and want to get an error indication
if there is not an exact match for the first argument (lookup_value).

I can get an error indication each cell with a problem by using the
4th argument to VLOOKUP and using the value "FALSE".

How do I get a indication that there a problem in either a fixed
location in the spreadsheet or a popop window?

I am using Office 2003, but, if need be, I can move to Office 2010.
I am using Windows XP and cannot upgrade.