M
Mark F
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.
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.