Need to match 2 columns, if a match found add info from 2nd column
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
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($A 1,$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 --- "Stratton" wrote: 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? |
All times are GMT +1. The time now is 02:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com