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
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