Remove formula from a cell after evaluating to true

[romanemul]

Hello,

Do anyone knows how to remove formula from cell after evaluating ?

for example

=VLOOKUP($B$3,$A1,1,FALSE))

After eval the cells are replaced again to #N/A only evaluated one giving me result .

Is there any workaround for this.


Thanks for any help.

Roman

 

[G12]

This is a very hard question to understand and I don't know what you are looking for as an output.
However, I can see your Vloolup doesn't have a range to lookup against. You are only looking at one cell.
No idea if this helps, but perhaps you could expand on your expectations.
G12

 

[glfiedler]

I do not understand what you are trying to do but there is, to my knowledge, no way a cell formula can erase itself.