Vlookup & ErrorType
Excel 97
The following equation is in cell B11. The array named arrayA is in the same
sheet as the equation.
IF(ERROR.TYPE(VLOOKUP(A11,arrayA,2,FALSE))=7,"Erro rType=7","ErrorType<7")
If A11 does not have a corresponding value in the first column of arrayA, the
equation correctly returns, ErrorType=7.
If A11 does have a corresponding value in the first column of arrayA, the
equation incorrectly returns #N/A which is Error.Type 7
Why doesn't it return, ErrorType<7?
--
Chuck
|