Can i use VLOOKUP if table array contains only parts of strings from lookup value

5 pts.
Tags:
Microsoft Visual Studio
-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. COLUMN A: -DBL08602BKXL -DBLE35002GRL -SPJZ0751001BNM -SPJZ0751001BNL -DBL08602BKL -SPJZ0751001BNM COLUMN D: -08602 -E35002 -JZ0751001 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: -08602 -E35002 -JZ0751001 -JZ0751001 -08602 -JZ0751001 from column D:D Many thanxs in advance.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following