close

i have 2 worksheets. the 1st contains a table of companies with their
industry codes (4digits) and the 2nd sheet contains tables with industry
codes and data.
my problem is i have to match the codes in the 1st sheet to the data on the
2nd on either the first 4, 3 or 2 digits of the code. how do I incorporate
this into my VLOOKUP function?

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

    software

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