Thread: Need a formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken Wright
 
Posts: n/a
Default Need a formula

If the error is #NA then it should be ISNA used, else ISERROR may hide other
inadvertant errors.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------

"John Michl" wrote in message
oups.com...
Try
=IF(ISERROR(VLOOKUP,a1,B1:C10,2,FALSE),100%,VLOOKU P,a1,B1:C10,2,FALSE)

- John