Vlookup

[sburkhar]

I would like my VLookup to return a blank cell if the cell it's searching is blank. Can this be done?


thank you,
Sharon
Excel 2010

 

[Fluff]

Something like
=if(VLOOKUP(…)=0,"",vlookup(…))

 

[DanteAmor]

If in the cell you see a 0 as a result you can change the format of the cell to:


;;;

 

[Peter_SSs]

Something like
=if(VLOOKUP(…)=0,"",vlookup(…))

I would make it
=if(VLOOKUP(…)="","",vlookup(…))
so that a legitimately looked up value of 0 is not converted to "".