VLOOKUP w/ LEFT Function

Originally Posted by rocky1

Does the value in the table (left most value) equal only the five characters you are searching or are they the entire number? They must match.

Yep and they are also ascending.