Look up and string operation; fetch a value based on searching a partial string

Posted by Sam on Super User See other posts from Super User or by Sam
Published on 2012-10-16T04:47:19Z Indexed on 2012/10/16 5:10 UTC
Read the original article Hit count: 439

Filed under:

I have 2 sets of data. One set to be filled up by fetching relevant data from a data array.

DATA to be FILLED:

Part#1 Part#2 ------ ------- 4021006 3808587 3870480 3083410 3873905 3890030 4002065 3699803 3930218

ARRAY OF DATA:

Part#1 Part#2 ------ ------- 4021006;3808587 1 3808587 2 3870480;3083410;4002065 3 3083410 34 3873905 54 3890030 32 4002065;3930218 65 3699803 75 3930218 68

I need to match Part#1 and find Part#2.

EXPECTED OUTPUT

Part#1 Part#2 ------ ------- 4021006 1 3808587 1;2 3870480 3 3083410 3;4 3873905 54 3890030 32 4002065 3;65 3699803 75 3930218 65;68

Can anyone help.

© Super User or respective owner

Related posts about excel-2007