Hiding VLookup #N/A

[EmilyE]

I am using a VLookup in my spread sheet, however we don't always need every
line that the equation is on. When it's not in use the cell says #N/A. Is
there a way to hide that?

 

[Jim Thomlinson]

While you can use Conditional formattin gto hide #N/A you are better off to
avoid them in the first place...

=if(isna(vlookup(,,,)), "", vlookup(,,,))

there are some better versions of taht type of formula but that will get you
started.