R
RC
--
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,
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,