E
EJW
Hi I hope you can help...
I am using vlookup functions and as we know if it can't find a value i
returns a cell value of #N/A.
However the result of the lookup is used to calculate another part o
the worksheet. So if there is an error #N/A I want it to appear in th
spreadsheet either as a blank cell or as a value of 0.
Is this possible
I am using vlookup functions and as we know if it can't find a value i
returns a cell value of #N/A.
However the result of the lookup is used to calculate another part o
the worksheet. So if there is an error #N/A I want it to appear in th
spreadsheet either as a blank cell or as a value of 0.
Is this possible