vlookup returning 0 instead of blank

[bucci35]

Hi,
I have the following formula that is returning a 0 when the item can be found but the second cell over is blank. I want it to return blank.

IF(ISERROR(VLOOKUP(C7,Sheet2!$D$3:$H$5000,2,)),"",(VLOOKUP(C7,Sheet2!$D$3:$H$5000,2,0)))

I want this to return a blank when the item in C7 can't be found PLUS if the item in C7 can be found but the second cell over is blank.
Any ideas what I'm doing wrong here??

Thanks,
dan

 

[bucci35]

I'm using Excel 2010 and it returns values

 

[Aladin Akyurek]

I'm using Excel 2010 and it returns values

See post #7, the last formula, reproducing here:

=IFERROR(IF(VLOOKUP($C7,Sheet2!$D$3:$H$5000,2,0)="","",
   VLOOKUP($C7,Sheet2!$D$3:$H$5000,2,0)),"")

Additionally, if the values are text values...

=IFERROR(T(VLOOKUP($C7,Sheet2!$D$3:$H$5000,2,0)),"")

 

[T. Valko]

I'm using Excel 2010 and it returns values

Try this...

=IFERROR(IF(VLOOKUP(C7,Sheet2!$D$3:$H$5000,2,0)="","",VLOOKUP(C7,Sheet2!$D$3:$H$5000,2,0)),"")

 

[bucci35]

OOPS, I must have typed an error, you are absolutely correct, it does work!!!
Thank you so much for your help, you are a life saver!!!!
Have a great day....
Dan