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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
How to use MSExcel to plot Column A against Col B? 8
using error type and if statement to return a value. 6
lookup and return column number 2
GetSystemMetrics32(n) Question 3
Locate text in range (multiple occurrences) and report other cell insame column? 10
Look up if a value from an array "A" is in either array "B" or "C" 8
Determine if a month falls between two dates. 5

Back
Top