handling #N/B

  • Thread starter Thread starter frens
  • Start date Start date
F

frens

Hello,

the following gives the text "nothing there" if Horizontal Lookup doe
not find the value X, and else SHOULD return the result of finding tha
value, that is, should return the value in the corresponding third (3
row from X.

=IF(error.type(HORIZ.lookup(X;B49:I51;3)=7);"nothin
there";HORIZ.lookup(X;B49:I51;3))

Whatever I try, the 'else' part does not respond at all, it alway
returns "#N/B".
I guess that is because if it does finds the value X, the IF par
returns "#N/B", and so the whole formula gives "#N/B".

How to make the else part work?

Thank
 
Hi assuming you're using a Dutch Excel version try:
=IF(ISNB(HORIZ.lookup(X;B49:I51;3));"nothing
there";HORIZ.lookup(X;B49:I51;3))

Note: Of course also change IF and the HORIZ.lookup to your language
equivalents
 
Back
Top