Remove #N/A

Questions and answers about PlanMaker 2018 for Windows
Post Reply
User avatar
Princy557
Posts: 185
Joined: Wed May 18, 2011 10:32 am

Remove #N/A

Post by Princy557 » Tue Sep 03, 2019 12:38 pm

HI,
how to remove the #N/A from a cell with this in it. (While it's empty)
=IF(LEN(VLOOKUP($C$6,'Customer List'!$A$2:$K$25,2,0))=0,"",VLOOKUP($C$6,'Customer List'!$A$2:$K$25,2,0))

Regards
Princy557 :?
Regards

Princy557

miguel-c
SoftMaker Team
SoftMaker Team
Posts: 597
Joined: Wed Jun 05, 2019 12:02 pm

Re: Remove #N/A

Post by miguel-c » Tue Sep 03, 2019 2:37 pm

Hi, you could use the IFERROR function to replace #N/A by something of your choosing.
Example:
=IFERROR(VLOOKUP($C$6,'Customer List'!$A$2:$K$25,2,0),"message")

User avatar
Princy557
Posts: 185
Joined: Wed May 18, 2011 10:32 am

Re: Remove #N/A

Post by Princy557 » Tue Sep 03, 2019 3:21 pm

Hi miguel-c

Works a treat thanks for the quick response.
Regards Princy 557
Regards

Princy557

Post Reply

Return to “PlanMaker 2018 for Windows”