Nov 06 2019 12:36 PM
I would like to "value" the results of a vlookup BUT in the same column not value the "sum" of those vlookups. Basically, I want the vlookups to be converted to values (Which I know how to do) but not value the results of the sum. Also, I am trying to stay away from protect/lock/unlocking of cells and valuing specific cells at a time.
Any help?
Nov 06 2019 01:09 PM
Nov 06 2019 01:12 PM
@WendyK518 Unless you do it manually, the only way to convert formulas to values is with VBA. It's certainly doable, but you'd need to lay out your process. For example, you could have a button that applies your VLOOKUPs, recalculates the sheet, then values them. If that sounds like a plan, then I'd start by recording a macro doing that. You can always post the code back here for someone to clean up.
Hope that helps,