Change Original value inside Vlookup

Are you saying that you give a code, a formula looks up the corresponding description, you want to type in a different description, and then have that description updated in column F?

If that's it, it is possible but it requires VBA. That's the only way to change a cell that has a value instead of a formula.

It is not 100% clear what you want to achieve. Do you want to:

... Now change that found value to something else inside cell B1, if not then inside B2. And this causes change of value in F10 so next time 0010101OL is written in A1 this new value will show in B1.

If you need something like it, formulas wouldn't help. You need to use VBA for that
Let's say you want to input replacement in B2 (will be easier, because you do not destroy formula in B1 this way).

Rightclick on your worksheet tab, select edit code from popup menu and paste such code:

Please Login or Register  to view this content.

Use Cell C1:C10 as helper column.
worksheet event code.

Please Login or Register  to view this content.

To paste the code
Right click of sheet tab
Select--> View Code
Paste the code.
Close window

Everything works now, thank you once again.

Hi there, apologies to resurrect a dead thread, but I am attempting to use the latest code from kvsrinivasamurthy, except I am attempting to make the changes to a table on a separate sheet. I ended up changing the code to what I've pasted below, but it doesn't seem to work at all for me. Can anyone help me figur e

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

PL upload the file.

Originally Posted by kls1022

Hi, thanks for the quick reply, here is the file.

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread