questions that come to mind are if the list is in ascending order (if not add the 4th arguement "false" to the vlookup function. Also, are you sure there are not hidden spaces in the alphanumerics - try using the trim function in the vlookup.