Vlookup

  • Thread starter Thread starter budlink
  • Start date Start date
B

budlink

Ok I am still confused. This is what I have.


Sheet 1
I have a list of Full names Column A Column B is empty Column C is
empty
with addresses in Column D

Sheet 2
List of names Full names in Column A List of User names in Column B

I want to match the full name on sheet 1 with the full name on sheet 2
and
place the corresponding user name in the empty column B on sheet 1

Please help!
Bud
 
Hi Bud
put the following in B1 on your sheet1:
=VLOOKUP(A1,'Sheet2'!$A$1:$B$999,2,0)
copy down

HTH
Frank
 
I can't see where anyone else has said anything about this
previously so I will start from the beginning.

On sheet 2, hightlight the data in column A & B.
Sort the data by column A.
Go to Insert menu item, select Name->Define.
In the "Names in Workbook" area type a name for your
range... I'll use Users.
Click Add, and then OK.

On sheet 1 Click onto Cell B1 (if that is where your data
starts).
Enter this formula

=VLOOKUP(A1,Users,2,FALSE)

Use False statement so that it will only pick exact
matches. If you don't you might be surprised what Excel
will give you as an answer.

Stever
 
ok that worked "kinda"

But one more problem, in the first list of names some are first nam
last name, and others are last name first name,

Same with the second list but not necessarily the same name.


Bu
 
Yikes! Been there before. I recently wrote a macro that
would grab the last name put it in a cell and then grab
the first name and put it in another cell. It works for
names that are in LASTNAME, FIRSTNAME order. Soounds
like you have some list maintenance to do.

I suppose that a macro could be written. Do you know VBA
at all?

Please email me at (e-mail address removed). I will respond
quicker.

Stever
 
Back
Top