VLOOKUP code deleted if user types in cell

[ipbr21054]

Hi,
I have this code in various cells,obvioulsy each with a different cell reference.

=IFERROR(VLOOKUP($B12,INDIRECT("INFO!$CV$2:$DB$"&COUNTA(INFO!$CV:$CV)),5,FALSE),"")

I select a customers name in cell B then VLOOKUP populates cells C D & E
Now column D refers to how much the customer has paid me.
9/10 the fee is always the same but today it was different.

So if like normal i select a customers name & the cell in column D has £30 applied todays fee was £50
If i manually type £50 into the cell then the VLOOKUP code is deleted.

Is there a workaround for this please so the VLOOKUP isnt deleted.
Or what can you advise

Thanks

 

[mumps]

When you type anything into a cell that contains a formula, the formula will always be over-written by the value.

 

[ipbr21054]

ok
so what do you advise in a situation like this please

 

[mumps]

Perhaps a macro would be able to do what you want. Perhaps you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Include a detailed explanation of what you would like to do using a few examples from your data and referring to specific cells, rows, columns and worksheets. If the workbook contains confidential information, you could replace it with generic data.