View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Paul James[_5_] Paul James[_5_] is offline
external usenet poster
 
Posts: 7
Default avoiding #N/A when using vlookup

I don't have an Option Compare statement in the worksheet module, so I must
be using the default of Compare Binary. In any event, the Sub is handling
the comparisons properly. The problem occurs after it gets through the if
statement when the number is within the range tested by the if, but isn't
listed in the Vlookup range.