Matching 2 list of data array, and return it as True if matched
 

Hi

I have 2 list array in the following collumns (both list are not sorted)
Array 1:
A - list of city names
B -list of language

Array2:
C - list of city names
D -list of language

I'd like to match array 1 & array 2, so in column E it will show "True" if a
city have the same language on both list and "False" if languages of the same
city is not matching. Any idea how to formulate this?

Matching 2 list of data array, and return it as True if matched
 

=D2=INDEX(B:B,MATCH(C2,A:A,0))

and copy down

--
__________________________________
HTH

Bob

"Venice" wrote in message
...
Hi

I have 2 list array in the following collumns (both list are not sorted)
Array 1:
A - list of city names
B -list of language

Array2:
C - list of city names
D -list of language

I'd like to match array 1 & array 2, so in column E it will show "True" if
a
city have the same language on both list and "False" if languages of the
same
city is not matching. Any idea how to formulate this?