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