Cells displaying formula with VLookup

[LisaM]

I edited my formula for adding '$' to the column range and now instead of the formula returning the proper value, it shows my formula? I know this question has been answered here before, but for the life of me cannot find it. I have tried F2. I have gone to Tools - Options - View and checked that the box wasnt checked to show formulas. I have formatted my range in my vlookup on both worksheets the same and they are both sorted in ascending order. Anyone have any suggestions as to what else I can try?

This is what my cell is displays:
<TABLE style="WIDTH: 161pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=215 x:str><COLGROUP><COL style="WIDTH: 161pt; mso-width-source: userset; mso-width-alt: 7862" width=215><TBODY><TR style="HEIGHT: 22.5pt" height=30><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 161pt; HEIGHT: 22.5pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl24 height=30 width=215>

<TABLE style="WIDTH: 161pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=215 x:str><COLGROUP><COL style="WIDTH: 161pt; mso-width-source: userset; mso-width-alt: 7862" width=215><TBODY><TR style="HEIGHT: 22.5pt" height=30><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 161pt; HEIGHT: 22.5pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl24 height=30 width=215>=VLOOKUP(A4,'Vendor Address Lookup'!$A$3:$H$462,3,FALSE)</TD></TR></TBODY></TABLE>
</TD></TR></TBODY></TABLE>
This is what my cell should display and what all the other cells display (corrosponding to the proper address):

<TABLE style="WIDTH: 227pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=302 x:str><COLGROUP><COL style="WIDTH: 227pt; mso-width-source: userset; mso-width-alt: 11044" width=302><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 227pt; HEIGHT: 12.75pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl24 height=17 width=302>P O BOX 224 </TD></TR></TBODY></TABLE>

 

[VoG]

Try formatting the cell as General then re-entering the formula.

 

[LisaM]

I am finding this fustrating. I did what you suggested and it still displays the formula and not the result.

However on a humorous note, if I select the insert function and use VLookup, the result shows in the helper box just not in my cell.

 

[LisaM]

Ah Ha! I saved the workbook. Closed it and when I re opened it, it was working fine. Not sure what the problem was but thanks!

 

[Aladin Akyurek]

I am finding this fustrating. I did what you suggested and it still displays the formula and not the result.

However on a humorous note, if I select the insert function and use VLookup, the result shows in the helper box just not in my cell.

Another procedure...

Select the formula cells, not showing results.
Activate Edit|Replace.
Set Find What to: =
Set Replace With to: =
Activate the Replace All button.