G Guest Mar 8, 2004 #1 I type in a vlookup formula in a cell and press enter. But instead of performing the function, the cell fills with the formula. How do I get the cell to display the proper vlookup value?
I type in a vlookup formula in a cell and press enter. But instead of performing the function, the cell fills with the formula. How do I get the cell to display the proper vlookup value?
J JE McGimpsey Mar 8, 2004 #2 Format the cell as General. If you have it formatted as Text, XL's parser won't recognize it as a formula.
Format the cell as General. If you have it formatted as Text, XL's parser won't recognize it as a formula.
