Hiding VLookup #N/A

  • Thread starter Thread starter EmilyE
  • Start date Start date
E

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?
 
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.
 
Back
Top