Solved

Error #N/A problem

Posted on 2013-11-22
6
149 Views
Last Modified: 2013-11-22
Folks,
The below code is OK. However if I have no value in cell B2 I get the error #N/A in the range A4:A12. I'm having a problem not showing that error with IF(ISERROR and I may not be doing that correctly, if it is what I need not to show the #N/A error which is my objective.
=IF(HLOOKUP($B$2,$J$3:$M$12,ROW()-2,FALSE)=0,"",HLOOKUP($B$2,$J$3:$M$12,ROW()-2,FALSE))

Open in new window

0
Comment
Question by:Frank Freese
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 4

Expert Comment

by:yuppydu
ID: 39669321
for #N/A you should use ISNA instead of ISERROR
0
 
LVL 4

Accepted Solution

by:
yuppydu earned 500 total points
ID: 39669331
or you can simply add an IF(b2="";"";IF(HLOOKUP($B$2,$J$3:$M$12,ROW()-2,FALSE)=0,"",HLOOKUP($B$2,$J$3:$M$12,ROW()-2,FALSE)))
0
 

Author Comment

by:Frank Freese
ID: 39669477
You suggestion works "almost" - if you will repost
IF(b2="";"";IF(HLOOKUP($B$2,$J$3:$M$12,ROW()-2,FALSE)=0,"",HLOOKUP($B$2,$J$3:$M$12,ROW()-2,FALSE)))
to
IF(b2="","",IF(HLOOKUP($B$2,$J$3:$M$12,ROW()-2,FALSE)=0,"",HLOOKUP($B$2,$J$3:$M$12,ROW()-2,FALSE)))

without the ; I can award you points. I do not want to post an incorrect solution.
0
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 

Author Comment

by:Frank Freese
ID: 39669935
yuppydu,
Please repost with changes so I can award you points.
Thanks you
0
 
LVL 4

Expert Comment

by:yuppydu
ID: 39669957
Sorry ; or , is just an argument separator. I didn't notice your system takes , therefore substitute ; with ,
0
 

Author Closing Comment

by:Frank Freese
ID: 39670004
thank you
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question