I am performing a VLOOKUP for names, not values, and I am wondering if I am able to create the lookup to look for last name first in one column, then if there are multiple names under the same last name, then it will look for the confirmation on the next column, the first name. This way it will reference the right number the corresponds.

I don't think that the vlookup has the capacity to do so, so I'm thinking of nesting another function to help.

I did have the names last name, first name, but I seperated them using "text to columns" for sorting purposes.

Any ideas?

Thanks!