B
bigtim
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.
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.