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

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

Post by U3RyYXR0b2 » Thu, 09 Oct 2008 22:25:04


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?
 
 
 

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

Post by TWF4 » Thu, 09 Oct 2008 22:55:00

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://www.yqcomputer.com/
Downloads:18,600 Files:362 Subscribers:60
xdemechanik
---