Vlookup for non-unique fields
 

Hi,

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

Eg.

Column 1 Column 2 Vlookup
A A A
B A A
B B B
B B B
B B

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 1 Column 2
1 A 1 A
3 B 2 A
4 B 3 B
5 B 4 B
5 B

Will appreciate any help. Thanks.