G
Guest
I have a wkbk with first names, last names, street. Another workbook has
first names, last names. I would like to compare the two and if both columns
match, I need to insert the street.
I have the following to tell me if there is a match
=IF(SUMPRODUCT(('[!ID.xls]all'!$B$2:$B$541=E11)*('[!ID.xls]all'!$C$2:$C$541=K11)), "Match", "Need to ID")
first names, last names. I would like to compare the two and if both columns
match, I need to insert the street.
I have the following to tell me if there is a match
=IF(SUMPRODUCT(('[!ID.xls]all'!$B$2:$B$541=E11)*('[!ID.xls]all'!$C$2:$C$541=K11)), "Match", "Need to ID")