That would require VBA code that would replace the formula with the hard-coded value.
We would need something to "trigger" this macro to run, presumably a value being entered/changed in cell G222.
Is that value entered manually?
Also, what cell is this VLOOKUP formula found in?