Even if value changes,data should remain unchanged

[adpatel]

I do have Excel sheet in which I have inserted IF formula,

i.e.=IF(C23='Data Nifty'!$AD$2,"CMP"," ")

use of erlier derived "CMP" as above mentioned, is done in another condition

i.e. =IF(A23="CMP",VLOOKUP($D$3,'Data Nifty'!$N:$Y,7,FALSE)," ")

now the problem is, if CMP gets change with other column then value disappers from original where erlier CMP was mentioned, I want to make sure that once CMP appears value do not change.

here below, pics given for better understanding.
1.https://i.stack.imgur.com/T3fnE.png
2.https://i.stack.imgur.com/yxTCv.png

any help will be highly appriciated by word of thanks.

 

[adpatel]

links of pics are...

1.https://i.stack.imgur.com/T3fnE.png

2.https://i.stack.imgur.com/yxTCv.png

 

[adpatel]

Links of pics are...

1.https://i.stack.imgur.com/yxTCv.png

2.https://i.stack.imgur.com/T3fnE.png