How to compare and extract data in two columns
 

Hi,

I have First Name, Last Name, UserID from one file. And again First Name,
Last Name only from second file. I need to compare the two data sets so as to
extract UserIDs. e.g

(The data is in same worksheet)

FirstName LastName UserID FirstName LAstName
John Adam Jadam Sara Kent
Bill Gate Bgate John Adam
..... ...
I need to extract names along with UserIDs that match.
Like: John Adam Jadam
Thanks

How to compare and extract data in two columns
 

FirstName LastName UserID FirstName LAstName
John Adam Jadam Sara Kent
Bill Gate Bgate John Adam

Assuming the above's in cols A to E, data from row2 down
Put in F2's formula bar,
then press CTRL+SHIFT+ENTER to confirm the formula (ie array-enter):
=index(c$2:c$100,match(1,(a$2:a$100=d2)*(b$2:b$200 =e2),0))
Copy F2 down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,700 Files:356 Subscribers:53
xdemechanik
---
"SK" wrote:
I have First Name, Last Name, UserID from one file. And again First Name,
Last Name only from second file. I need to compare the two data sets so as to
extract UserIDs. e.g

(The data is in same worksheet)

FirstName LastName UserID FirstName LAstName
John Adam Jadam Sara Kent
Bill Gate Bgate John Adam
.... ...
I need to extract names along with UserIDs that match.
Like: John Adam Jadam
Thanks