Anchor vLookup formula in a cell

Is there a way to create an anchor for vlookup or index/match formulas in Smartsheet? I have created an order form with a vlookup column in a sheet to pull in pricing. My concern is that when the resource sheet price changes then the price changes in my order form. I would like for the price to stay the same when the order is created. Currently is changes when the resource prices changes. Is there a way to lock or freeze this price in the order form cell?

Thanks in advance for any help or information!

Brad

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!