How to compare and extract data in two columns

  • Thread starter Thread starter SK
  • Start date Start date
S

SK

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
 
FirstName LastName UserID FirstName LAstName
John Adam Jadam Sara Kent
Bill Gate Bgate John Adam
Click to expand...

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
---
 
Back
Top