Hi,

I am racking my brain out here. How do I write this in a forumla:

If C16="Apple" then E16= the value in cell C3.

The problem comes in that the value in cell C3 changes all the time with a VBA script I wrote, but I want the value in E16 to show what is in cell C3 but not change when cell C3 is updated.

Make sense?