Here is a tiny trick to help reduce the pressure on you. Suppose column A
contains data like:

J Ravenswood
Ravenswood J

In C1 enter:
=IF(FIND(" ",A1,1)=2,A1,RIGHT(A1,1) & " " & LEFT(A1,LEN(A1)-2))
and copy down. This will convert all the names into
<initial<space<lastname

Then use any VLOOKUP() on columns B & C


--
Gary''s Student - gsnu200777


"Max Pressure" wrote:

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