Cross-Analyzing Lists
Hi,
I have two ginormous lists on two different excel documents. On the 1st document, column A is First Name, column B is Last name.
On the 2nd document Column A is Last Name, First Name.
How can I cross check to see if the people from Document 1 are on Document 2?
Thank you!
Hi,
Formula:
=MATCH(B1&" "&A1,['Second Document']Sheet1!A:A)
If the names are found in the second document it will return the row number, if not it will return #N/A.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
&", "&
.
Entia non sunt multiplicanda sine necessitate
i dont know where to put the formula?
In an unused column in the first document. e.g., in C1 and copy down,
=MATCH(B1 & ", " & A1, ['Second Document']Sheet1!A:A, 0)
Last edited by shg; 07-08-2014 at 01:58 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
gretta 
Register To Reply
Bookmarks