Quote Originally Posted by JOHN H. DAVIS View Post
It finds the first name in Column A and the second name in Column B. If the row numbers match then it puts the index number in a new column to the right. Otherwise it adds the new first name and last name to the current list at the bottom. I thought that was what you were looking for too happen.
Yes, that is the desired outcome, but this needs to be able to accept multiple names such that I copy and paste a list of first names, a list of last names, one index number for them, and then it loops through the lookup until the list inputted is exhausted.