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

V

Venice

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select and input data from a list 1
Convert list to UPPER, lower & Proper cases. 21
Need to return an array 3
Return array of data by date range 1
Search an array of sheets for an array of numbers & return count of numbers 11
Search two columns in list for first and last name and return Id 4
multiple file uploading - runtime error'13': type mismatch "While Counter <= UBound(FName)" 3
Help on matching some cells 1

Top