If the "formula just shows as text in the respective cell", then you have
the cell formatted as Text. To fix this:
-- Format the cell as General
-- Re-enter the formula

Regards,
Fred

"David Scarfe" wrote in message
...
I have used the following formula to replace N/A with 0, where there is no
value to return.

=IF(ISNA(VLOOKUP(D18,'KOTC_Customer Price List '!A:E,2,FALSE), 0
,VLOOKUP(D18,'KOTC_Customer Price List '!A:E,2,FALSE))

However, the formula does not register and the above formula just shows as
text in the respective cell.

I have even tried the IF ISERROR formula in Excel 2003 & 2007 and still
have the same problem.

Any ideas as to why this is happening, is much appreciated.

Best regards,

David


Submitted via EggHeadCafe - Software Developer Portal of Choice
The Software Project Loan Shark!
http://www.eggheadcafe.com/tutorials...ject-loan.aspx