Thread: Match cells

I need to create a worksheet that I can paste names of employees into a column or several columns and run a match on a government file that would have the names in a column such as lastname/firstname/middlename. I know how to do the text to column to split them out into 3 columns so that's not a problem. But the problem is that unless they are exact matches, the equation that I'm using doesn't work. There are times that the middle names or initials aren't even used but I need to match at least the last first names and have a list of possiblities to look at.

Thanks for any help you can give me.

You could write a macro to count how many matching Surname/Firstname matches you get and return a list to pick from if there is more than one.

Happy to have a go if you submit a sample of data to work from.