View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Pete
 
Posts: n/a
Default ISNA VLOOKUP any data prefixed with a "C7" cannot be found?

Maybe you have spaces at the end of a few codes in the lookup table -
use TRIM() to get rid of these.

Pete