• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 156
  • Last Modified:

Error #N/A problem

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
Frank Freese
Asked:
Frank Freese
  • 3
  • 3
1 Solution
 
yuppyduCommented:
for #N/A you should use ISNA instead of ISERROR
0
 
yuppyduCommented:
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
 
Frank FreeseAuthor Commented:
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Frank FreeseAuthor Commented:
yuppydu,
Please repost with changes so I can award you points.
Thanks you
0
 
yuppyduCommented:
Sorry ; or , is just an argument separator. I didn't notice your system takes , therefore substitute ; with ,
0
 
Frank FreeseAuthor Commented:
thank you
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now