Vlookup(ignore 0)

**whatsmyname** · 06-12-2010, 12:08 PM

Hello everyone,

How is everybody? I hope good.

I have a vlookup formula I am having trouble with. It is looking into 2 different cells in the formula. Works good but I am having a little bit of trouble. I want the formula to look at one cell and if it has a "0" in it I want it to look at a different cell. Right now I have it to look at one cell and if it sees that, that cell is empty then it will look at the other cell. But, due to conditions out of my control I now need it to work as if the cell had a "0" in it or if that cell is empty.

Your help is greatly appreciated. Thank you.

'=IF(C13="","",VLOOKUP(C13,Data,IF(VLOOKUP(C13,Data,5,FALSE)="",4,5),FALSE))'

**protonLeah** · 06-12-2010, 02:53 PM

....now need it to work as if ... "0" ... or ...is empty...

Please Login or Register  to view this content.

**whatsmyname** · 06-12-2010, 06:08 PM

Okay. I see where you are going. The thing is, in my formula it's not weather or not C13 has a zero or is empty. It's weather or not "C13,DATA,5" has a 0 or is empty. I took your formula and tried it in a couple of different ways and I still couldn't get it to work. Any other ideas?

Thank you so much for your help.

**NBVC** · 06-12-2010, 06:44 PM

Vlookup returns a 0 if the result cell has a blank or 0 in it.. so you probably just need to change the ="" to =0

e..g.

=IF(C13="","",VLOOKUP(C13,Data,IF(VLOOKUP(C13,Data,5,FALSE)=0,4,5),FALSE))

**whatsmyname** · 06-14-2010, 12:21 AM

That did it! Great I thank you very much for your help. I knew it had to be something simple like that. I didn"t even think of that.

Thank you. Have a nice day!