Solved: Replace Formula with code

[YasserKhalil]

Good day everybody
I have a workbook with VLOOKUP formula..
I want to replace the formula with the code
Is it possible??

[Bob Phillips]

Why do you want to do that, the formula will be (far more) efficient.

[YasserKhalil]

Because the original file is very large - I think because of the formulas -
The workbook contains 100.000 record

[Bob Phillips]

If your lookup table is sorted, as it appears to be, the formula can be made more efficient by using ,TRUE instead of ,0

[YasserKhalil]

Is there a way to convert the formulas to code?

[mdmackillop]

Named ranges used for simplicity

Sub Macro2()
With Range("Price")
.FormulaR1C1 = "=VLOOKUP(RC[-2],Data,2,FALSE)"
.Value = .Value
End With
End Sub

[YasserKhalil]

Thank you very much Mr. mdmackillop
I'm pleased with your solution