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.
全站熱搜