vlookup that inputs info as a value & not a formula

[katiapro93]

Can some one help? I think its a quick fix, but maybe I am wrong. I want to do a gloomily and when it finds it I need for the info to be knitted as the value & not the formula, as I have another column looking at that column & doing a vlookup of itself. Right now it won't work with the column showing a formula, but if I type in the number, it works. Any suggestions?

 

[katiapro93]

Can some one help? I think its a quick fix, but maybe I am wrong. I want to do a gloomily and when it finds it I need for the info to be knitted as the value & not the formula, as I have another column looking at that column & doing a vlookup of itself. Right now it won't work with the column showing a formula, but if I type in the number, it works. Any suggestions?

Sorry I am typing from my phone that changes what I say. The word gloomily should be vlookup. Knitted should be input