Hi,

The formula below works well. However, sometimes the result is a "#N/A" due
to incorrectly entering the data (a typo). It is a lookup formula and
causes a break in the macro. I'd like to incorporate something that if a
"#N/A" happens it is just the same as FALSE and results in "apples".

The formula is:

=IF(Data!S9="TRUE",Data!R8,"Apples")

I have read the Excel help and tried to resolve this but alas no resolution.

Any help would be greatly appreciated.

regards

Jeff