Vlookup should not update old entries in a worksheet

dwinti

New Member
Joined
Sep 13, 2014
Messages
1
Hi,

a friend of mine uses Excel for his invoices he writes as home care nurse.

Im a sheet he has a table containing Codes , descriptions and price of the care activity. With a Vlookup formula he combines the prices with the patients. But annualy when he get new prices, old the old entrie are updated to with the new prices.

This is a major problem when he has to complete his taxe form.

Is there any solution to prevent Excel from updating old records when data in refering table changes, or is there a better formula to achieve this problem? If this needs VBA programming is there anyone who could do this for us.

Thanks for your help

Dwinti
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK
Once he has the records and knows they don't need to be updated highlight the records, copy then right click and select paste special and use the values option. This will convert all of the calculations to values and they will never update.
 
Upvote 0

Forum statistics

Threads
1,226,504
Messages
6,191,431
Members
453,657
Latest member
DukeJester

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top