midfieldgeneral11
Active Member
- Joined
- Feb 11, 2004
- Messages
- 464
Can you help, I have TWO spreadsheet both with a list of names.
I am trying to do a look up table to match the two spreadsheets.
But….
I have a name in the spreadsheet like John L Workington but I may have one named John Workington.
Is there a way to do a look up table to look some of the cell and state that this is a match instead of looking at the whole cell.
Please help Simon
I am trying to do a look up table to match the two spreadsheets.
But….
I have a name in the spreadsheet like John L Workington but I may have one named John Workington.
Is there a way to do a look up table to look some of the cell and state that this is a match instead of looking at the whole cell.
Please help Simon