close

Hi,

I'm trying to do a vlookup for 2 columns of data but these 2 columns have
non-unique data.

Eg.

Column 1Column 2Vlookup
AAA
BAA
BBB
BBB
BB

In the Vlookup column, Excel returns 2 As in Column 2 when in fact there is
only 1 A in Column 2. Is there any way to get Excel to return only 1 A and
the other to be #N/A? Will 2 condition Vlookup be of use here considering
that the data in Columns 1 and 2 each actually relate respectively to another
unique set of data?

Eg.

Unique Field Unqiue Field
for Column 1 for Column 2
Column 1Column 2
1A1A
3B2A
4B3B
5B4B
5B

Will appreciate any help. Thanks.

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

    software

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