I know this is simple, but for the life of me I cannot figure it out €“ your
help would be greatly appreciated!!

I need to create a €œvlookup€� that is based not only on the exact characters
of the Lookup_Value field, but also off the length. For example, I have a
list of general part numbers in file1, and a list of parts with extensions
and the parts details in file2. Using the example below, I would like to
lookup on the part in file1, and based on the characters and length of the
part search only for an exact match for that part in File2 .

In this case for the first part, the lookup function would only look at the
first 6 characters of the field before finding an exact match to ABC123; the
lookup for the second part would look only at the first 7 characters. Using
True in the Range_vlookup field for a €œclosest match€� does not work. Since
the part numbers vary in character length and extension length I cannot
lookup a LEFT xxx on my parts in File2.

File 1 File2
PART PART w extension Package
ABC123 ABC123abcde BAG 14
DEF4567 DEF456712fg BAG 15

I hope I have explained this well enough for you to get an idea of what I
need. Any help would be appreciated!!