Merge? VLookUp? Hmm...

[Kellia]

Hi,

I have 2 worksheets. Worksheet 1 has a list of names in Column A with info
in Column C. Worksheet 2 has a list of names (the same but fewer names than
in worksheet 1) and additional info in Column B.

I'd like excel to put the information from Worksheet 2, column B into
worksheet 1, column B whenever the names match up.

Make sense? If there were numbers, I think I could use an if statement or
fiddle around with VLookUp. I'm not too familiar with merge, but this
command comes to mind.

Example below:
Worksheet 1
Column A / Column C
Dot Matrix /
Barf /
LoneStarr /
Kellia Meharry
Dark Helmet /
President Skroob /

Worksheet 2
Column A/ Column B
Kellia Meharry / {3}
President Skroob / {2,0}
Dot Matrix / {4}
Lone Starr / {4,3,2,1,0}
Barf / {4,3,2,1,0}


This has been plaguing me for months and I've been doing the work by hand--
ugg. Any guidance is greatly appreciated.

"you see that evil will always triumph, because good is dumb." just joking

 

[JLatham]

VLOOKUP() should do the job for you.

Assumptions:
names list on sheet2 goes from row 2 down to row 101
name list on sheet1 starts at row 2, so our first formula goes into B2 on
Sheet1:

=VLOOKUP(A2,Sheet2!$A$2:$B$101,2,FALSE)
and fill down column B on sheet1 as far as your name list goes on that sheet.

If the list on Sheet2 may grow and you don't want to have to constantly do
maintenance on it, you can rewrite the formula as:
=VLOOKUP(A2,Sheet2!$A$:$B$,2,FALSE)
The penalty is a little longer to finish the task, the benefit is you only
have to extend the formula down sheet1 as its list of names gets longer
without having to constantly rewrite the formula because the list of names on
Sheet2 got longer.

 

[JLatham]

Oops, didn't clean up the 'rewrite' formula enough, should be (for Cell B2 on
Sheet1)
=VLOOKUP(A2,Sheet2!$A:$B,2,FALSE)