View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chuck[_11_] Chuck[_11_] is offline
external usenet poster
 
Posts: 58
Default 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