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.

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