Need to match 2 columns, if a match found add info from 2nd column

S

Stratton

I'm comparing 2 lists of serial numbers. The first list is smaller. The 2nd
list is more extensive and contains information in 3 more columns that needs
to be added to the 1st list.

Example:

12345678 X 12345677
12345678 Mr Joe Bloggs Feb 08 £1500
12345679 X 12345679 Mr Fred Smith Apr 08 £600
12345681 X 12345680
12345682 X 12345681 Mrs Jane Doe Apr 08 £750

If the number exists in both columns, I need the remaining info (name, date,
amount etc) to be inserted at X.

Please can someone help?
 
M

Max

A simple index/match would be one way

Assuming from your posted data, the 1st list is in col A,
the 2nd is in cols C to F, with data from row1 down

First, insert 3 new cols in-between the 2 lists (for the data to be
extracted)
so that you have the 1st list in col A, with the 2nd list in cols E to H

Then put in B1:
=IF(ISNA(MATCH($A1,$E:$E,0)),"",INDEX(F:F,MATCH($A1,$E:$E,0)))
Copy B1 to D1, fill down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik
 
Top