How do I pull/lookup data from another cell only once?

[Dnykato]

Ok, I've really been attempting to figure this out myself, but I'm not very good with excel, so please bear with me.

Here's what I managed to do.

I have a sheet that pulls the price of an item from a table on another sheet.

In this sheet, cell H319 has the following formula
=IF(G319>0,VLOOKUP(E319,Prices!A$1:B$99,2,FALSE)*'Sales (2)'!G319,"")

Where it pulls from my table on another sheet.

Great, that part was easy.
Here's the thing. If I want to update my price, and decide to change it on my price sheet, it modifies ALL the other cells that used that data. Is there a way to prevent that from happening? Where it only pulls the price from the moment I initiated the IF formula? (There's MUCH more I'd like to ask, but I'll save those for another post)

Essentially, I would like to keep the original 317 cell data in tact, being able to keep historical data.

Thank you for your assistance!

 

[mumps]

I believe that you would need to use a macro to do what you want. You could also manually copy the cell, then right click the cell, select "Paste Special" and select "Values".