I have two spreadsheet in which I am looking for duplicate customer names.
1st - "Customers"
2nd - "Orders"
In column A of my Customers spreadsheet I have the following formula
=IF(ISERROR(MATCH(E2,Orders$D2:D1000,0))=FALSE, "Y","N"). This allows me to see if a name in my Customer spreadsheet (column E is a field of names) is also in my Orders spreadsheet (column D is a field of names). My end results is either a Y indicating a duplicate or a N for no duplicates.
What I am looking to do next is to place in column B of my Customers spreadsheet the date that coincides with the duplicating customer name. Sorry to be confusing. If a customers name is found in the Orders spreadsheet I need to know what date has been given to this customer (column L in the Orders spreadsheet contains the date information).
However, on numerous occasions a customers name is found in the Orders spreadsheet more than once meaning there may be more than one date which needs to be placed in column B of my Customers spreadsheet.
I am stuck as to how to gather this information. Any help would be greating appreciated.