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.
|