Vlookup on 0 cell entry

  • Thread starter Thread starter brian.baker13
  • Start date Start date
B

brian.baker13

Hi

I have some vlookup formulas on looking at cells with a 0. I am
getting a return of #n/a in the cells. I would like these to be blank.
How do I do this please?

Thanks

Brian
 
Hi

I have some vlookup formulas on looking at cells with a 0. I am
getting a return of #n/a in the cells. I would like these to be blank.
How do I do this please?

Thanks

Brian
Click to expand...

Try this formula:

=if(iserror(YOURFORMULA),"",YOURFORMULA)

hth

Carlo
 
Back
Top