Vlookup on 0 cell entry

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
 
C

carlo

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
 
Top