Hi,
Here's what I've got:
Column A has 400 usernames in 2 different formats:
<lastname<firstinitial and <firstinitial<lastname
(and yeah, they're all mixed up)

Column B Has all these users listed by last name

I'm trying to reconcile Column B against Column A. I have some experience
with the vLookup function but I don't know how to make this scenario work.

Any assistance would be greatly appreciated!
-Max