close

I want to automatically fill in column B (from a seperate list) based on part
of the cell in column A.

For instance,
A312 = quot;MW3-11315AHquot;

Now, I would like to fill in B312 with quot;SHANKquot;, based on the quot;MW3quot; at the
beginning of the text string in A312.

Also,
A313 = quot;B2-P-N49B-A0014quot;

I would like to fill in B313 with quot;ARM ASSYquot;, based on the quot;A0014quot; at the
end of the text string in A313. However, the numerical portion of quot;A0014quot;
(A####) will change.

I was hoping to create a list on another worksheet, and use VLOOKUP, but I
am unsure as to the implementation of wild-card or partial-content lookups.

Any help is GREATLY appreciated!

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄