G
Guest
I have this equation in the column E cells:
=IF(VLOOKUP(D3,$H$2:$I$17,2,FALSE)>0,VLOOKUP(D3,$H$2:$I$17,2,FALSE)*C3,0)
What I am trying to do is if there is no data in column D cells, I want it
to enter a zero (0). It is currently returning the #N/A error, wich is the
same error if I only had the vlookup () equation.
I want it to return a zero (0) because at the bottom I am summing the
content wich will return #N/A if one cell contains that message.
Thanks for any help
=IF(VLOOKUP(D3,$H$2:$I$17,2,FALSE)>0,VLOOKUP(D3,$H$2:$I$17,2,FALSE)*C3,0)
What I am trying to do is if there is no data in column D cells, I want it
to enter a zero (0). It is currently returning the #N/A error, wich is the
same error if I only had the vlookup () equation.
I want it to return a zero (0) because at the bottom I am summing the
content wich will return #N/A if one cell contains that message.
Thanks for any help