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 :)