Dear All,
I would appreciate if anyone could advise on the following.
I have two seperate spreadsheets: Sheet 1 with data of 50 clients and Sheet 2 with data of 35000.
I currently have a look up in place which looksup and matches client names (Column A on both sheets) from Sheet 1 to Sheet 2, and indicates "Possible Match" or "No Match".
I wish to also create a lookup which can correlate matching dates of birth, but I need this to happen after the names have been correlated. The goal would be to have a key match column which only states possible matches if the name primarily, and date of birth secondarily appropriately match.
Is there a way of doing this?
The dates may be formatted slightly differently on each sheet, does this present a problem? e.g 10th Aug 2013 and 10-Aug-2013
Many thanks for your time,
Jose
Bookmarks