Turning #N/A to a zero...??
 

Hello there. my name is Tim and i am creating a spreadsheet which
calculates the cost of various painting and decorating costs.

However i have encountered a problem when targetting a lookup. I get
'#N/A' in the cell.


the equation is:
=VLOOKUP($D26,emulsion_costs,2,FALSE)

this targets a v-lookup. how can i create a v-lookup which will turn
this '#N/A' to a zero when there is nothing selcted in D26?

Any help much appreciated. :confused:

Big Tim.


--
bigtim
------------------------------------------------------------------------
bigtim's Profile: http://www.excelforum.com/member.php...o&userid=23747
View this thread: http://www.excelforum.com/showthread...hreadid=374118

=IF(ISNA(VLOOKUP($D26,emulsion_costs,2,FALSE)),0,V LOOKUP($D26,emulsion_costs,2,FALSE))

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=374118

Thank you that worked brilliant!

The only problem i have now is that i have a cell that divides an
*area* specified by the -cost of paint per litre-, which is then
divided by the _coverage__ which works out the cost of paint:

=*D23**-F28-/_F27_

The problem that i have is before a paint is selected it remains '0'
and i get a '#DIV/0' in this cell. Is there any way of getting round
this so that it makes a zero instead of this?


--
bigtim
------------------------------------------------------------------------
bigtim's Profile: http://www.excelforum.com/member.php...o&userid=23747
View this thread: http://www.excelforum.com/showthread...hreadid=374118

=IF(ISERR(D23*F28/F27),0,D23*F28/F27)

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=374118

Thank you Mangesh.


--
bigtim
------------------------------------------------------------------------
bigtim's Profile: http://www.excelforum.com/member.php...o&userid=23747
View this thread: http://www.excelforum.com/showthread...hreadid=374118

Just wanted to say Thank you. This really helped me out.
Kate
--
Center for Governmental Research
Research/Technology


"mangesh_yadav" wrote:


=IF(ISNA(VLOOKUP($D26,emulsion_costs,2,FALSE)),0,V LOOKUP($D26,emulsion_costs,2,FALSE))

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=374118