If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Find matching records in two tables using mulitiple criteria
-- RCIn this case there are two tables of data of different sizes copied into the same worksheet. What is needed is to find each row of records in the first table that contains matching data to the rows of records in the second table by using multiple criteria. Here is an example below where the first table is located in columns A through D and the second table in columns F through I. The idea is to put a function in the cells in column E that will return a value (such as 1 or 0, or Yes or No, or True or False) to indicate the record on the particular row in the first table has a match, or does not match, a record contained in any row in the second table. A B C D E F G H I 1 ID# LN FN Color Match? ID# LN FN Color 2 321 Adams Alan Green No 321 Adams Alan Red 3 321 Adams Alan Red Yes 432 Allen Bob Red 4 432 Allen Bob Red Yes 543 Baker Dan Green 5 432 Allen Bob Green No 765 Collins John Green 6 654 Barber Sam Green No 7 765 Collins John Red No 8 765 Collins John Green Yes Thanks, -- RC |
Thread Tools | |
Display Modes | |
|
|