I am not entirely sure I follow what is you're looking to do - a dummy file with expected results may help... it sounds as though you may be able to do what you want using Evaluate but if you want the result of the looked-up formula in N13 you will end up overriding the initial VLOOKUP formula that retrieved the formula in the first instance... I think we need to see your proposal in action.