# 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))
``````
###### Who is Participating?

Commented:
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

Commented:
for #N/A you should use ISNA instead of ISERROR
0

Author 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

Author Commented:
yuppydu,
Please repost with changes so I can award you points.
Thanks you
0

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

Author Commented:
thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.