Remove #N/A

[Princy557]

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

[miguel-c]

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")

[Princy557]

Hi miguel-c

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