Vlookup and Replace?

[terresf]

Hello,

Is there a way to do a vlookup so that the info returned can replace the info you are using to look it up? I have a column of code that stands for dates, so I want to turn it into the actual date which I get from another book. I have to do this weekly. But the page that the code comes in on is formulated with lots of other info, so I'm just looking to replace this one column without otherwise altering the sheet.

 

[dreid1011]

Hello,

Is there a way to do a vlookup so that the info returned can replace the info you are using to look it up? I have a column of code that stands for dates, so I want to turn it into the actual date which I get from another book. I have to do this weekly. But the page that the code comes in on is formulated with lots of other info, so I'm just looking to replace this one column without otherwise altering the sheet.

You will need to use some VBA to replace the values in the cells. Could you please post some sample data of both sheets and your desired results?

 

[terresf]

You will need to use some VBA to replace the values in the cells. Could you please post some sample data of both sheets and your desired results?

You will need to use some VBA to replace the values in the cells. Could you please post some sample data of both sheets and your desired results? This is a little beyond me and I can't alter this computer, so thank you anyway.