Formula will not return value in cell...

[mimih23]

Hello!
I have implemented a successful Vlookup formula but the actual results will not populate the cell. Here's an example:

<TABLE style="WIDTH: 294pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=391 border=0><COLGROUP><COL style="WIDTH: 91pt; mso-width-source: userset; mso-width-alt: 4425" width=121><COL style="WIDTH: 203pt; mso-width-source: userset; mso-width-alt: 9874" width=270><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-RIGHT: #e0e0e0; BORDER-TOP: #e0e0e0; BORDER-LEFT: #e0e0e0; WIDTH: 91pt; BORDER-BOTTOM: #e0e0e0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=121 height=20>44XXXXXXXX453</TD><TD class=xl63 style="BORDER-RIGHT: #e0e0e0; BORDER-TOP: #e0e0e0; BORDER-LEFT: #e0e0e0; WIDTH: 203pt; BORDER-BOTTOM: #e0e0e0; BACKGROUND-COLOR: transparent" width=270></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-RIGHT: #e0e0e0; BORDER-TOP: #e0e0e0; BORDER-LEFT: #e0e0e0; BORDER-BOTTOM: #e0e0e0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>44XXXXXXXX307</TD><TD class=xl63 style="BORDER-RIGHT: #e0e0e0; BORDER-TOP: #e0e0e0; BORDER-LEFT: #e0e0e0; BORDER-BOTTOM: #e0e0e0; BACKGROUND-COLOR: transparent">=VLOOKUP(B:B,Sheet2!A1:B2838,1,FALSE)</TD></TR></TBODY></TABLE>

Instead of returning the exact match from the left, it just populates the formula. I've used the trim macro and everything is formatted as text. I just need to see the match criteria. It should look like this:

<TABLE style="WIDTH: 294pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=391 border=0><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-RIGHT: #e0e0e0; BORDER-TOP: #e0e0e0; BORDER-LEFT: #e0e0e0; WIDTH: 91pt; BORDER-BOTTOM: #e0e0e0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=121 height=20>44XXXXXXXX453</TD><TD class=xl63 style="BORDER-RIGHT: #e0e0e0; BORDER-TOP: #e0e0e0; BORDER-LEFT: #e0e0e0; WIDTH: 203pt; BORDER-BOTTOM: #e0e0e0; BACKGROUND-COLOR: transparent" width=270></TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl63 style="BORDER-RIGHT: #e0e0e0; BORDER-TOP: #e0e0e0; BORDER-LEFT: #e0e0e0; BORDER-BOTTOM: #e0e0e0; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>44XXXXXXXX307</TD><TD class=xl63 style="BORDER-RIGHT: #e0e0e0; BORDER-TOP: #e0e0e0; BORDER-LEFT: #e0e0e0; BORDER-BOTTOM: #e0e0e0; BACKGROUND-COLOR: transparent">44XXXXXXXX307</TD></TR></TBODY></TABLE>

Thanks!

 

[VoG]

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