Hi all
I have a worksheet that contains a formula that takes the form
=IF(ISNA(My_Expression),0,My_Expression)
The precise formula is
=IF(ISNA(MATCH(A18,Rates!FromDate)),0,MATCH(A18,Ra tes!FromDate))
the overall expression therefore never evaluates to #N/A

This worksheet is intended as a template. The user duplicates the worksheed
are required via
Edit/Copy or move sheet/copy sheet.

However, whenever I duplicate the template as above, the corresponding cell
that should contain the above expression simply contains the expression
=#N/A

How do I get around this, please? I would rather not use VBA.

Thanks

--
Return email address is not as DEEP as it appears