Now what was in A2, what was in $C$2:$C$35 (or the part that you expected the result from), what did you expect as result and what
was the actual result of your formula?
We are nor clairvoyant!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Wannano" wrote in message ...
| Col A: Text to lookup up
| Col B: formula =VLOOKUP(A2,$C$2:$C$35,1,FALSE)
| Col C: Lookup List
|
| All 3-digit alpha (ABC, EXD, etc)
| --
| Texas Wannano
|
|
| "Toppers" wrote:
|
| First, what is the VLOOKUP formula you used?
|
| And perhaps it is returning a different (incorrect) column ..parameter wrong?
|
| "Wannano" wrote:
|
| The results of a Vlookup function was a number versus the text in the cell.
| Does anyone know why?
| --
| Texas Wannano