So I have various Vlookups for a sales log entry I'm trying to do. Only problem is I want it to after it does the vlookup and shows the value, I want it to convert permanently to text and remove the vlookup formula.

Is this best accomplish with a macro? or is there an option to do this best if possible?

for example

i'm using vlookup to display current quantity values in a sales entry log. But I want it to record a history of lookups at the current time saved. so that they dont' all change as the quantity changes.