-Column A contains whole bar code number (combination of numbers & letters,15-23 characters lenght),column has 1000 rows & there can be duplicates in it.
-I need to use column D is array (109 rows) containing only midle parts of the bar code number witch lenght allso can vary by number of characters .
Example:in column A:Xrow there is a cell with string "DBL08602BKL",in column D:Xrow is cell with string "08602".Value from the column D is middle part of string from the cell from column A.
I can't use MID cause part of string(D) is not allways on the same position in whole string(A).
Can i use VLOOKUP in the way that LOOKUP VALUE = „DBL08602BKL“ & LOOKUP ARRAY contains „08602“ (part of lookup value string)???
Only thing that matches in corresponding cell from A:A & corresponding cell from D:D is exact same order of common characters.
In same row as DBL08602BKL from column A:A i need to VLOOKUP 08602 from column D:D in column B:B.
As the result of function in column B:B should be:
from column D:D
Many thanxs in advance.