I have a spreadsheet that I am trying to perform a comparison against but I'm not getting many hits.
I've use the vlookup function to compare fields but the problem is, neither spreadsheet has an exactly equal identifier.
For example
Spreadsheet Name Address ID #
1 John H. Smith 123 N. Mockingbird St. 12-345
2 John Smith 123 North Mockingbird Street 12345
How would I return matches on this data, even without the info exactly matching?
Thank you
I've use the vlookup function to compare fields but the problem is, neither spreadsheet has an exactly equal identifier.
For example
Spreadsheet Name Address ID #
1 John H. Smith 123 N. Mockingbird St. 12-345
2 John Smith 123 North Mockingbird Street 12345
How would I return matches on this data, even without the info exactly matching?
Thank you
