Assumes your lookup formula is in cell H4...
Enter this formula in your "fixed location" cell: =IF(ISERROR(H4),"PROBLEM","")
'---
Jim Cone
Portland, Oregon USA .
http://www.mediafire.com/PrimitiveSoftware .
(Special Print XL add-in: long columns printed side by side)
"Mark F"
wrote in message
...
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.