vlookup formula with isblank or iserror formula

krpatel · Mar 15th 2017

i upload file
i put vlookup formula in sheet 1 and show 0 (zero) in cell B2. i want to show as a blank when there is no data in sheet 2 col B vat no.
sheet 1 create vlookup formula
sheet 2 contain data

**NBVC** · Mar 15th 2017

Re: vlookup formula with isblank or iserror formula

If you never want to show 0 as a result, then it would be better to format the cells to hide the 0.

Format the Cell as Custom with Type as: [COLOR="#0000FF"]0;-0;;@[/COLOR]

Otherwise you can use this formula:
[COLOR="#0000FF"]
=IF(VLOOKUP(A2,Sheet2!A2:C50,2)="","",VLOOKUP(A2,Sheet2!A2:C50,2))[/COLOR]

vlookup formula with isblank or iserror formula

Participate now!

Share

Users Viewing This Thread