Matching

[Guest]

I have this information in worksheet #1
Code SS#
301 000-00-0000
301 111-11-1111
302 222-22-2222
303 112-22-1122

And this in worksheet #2
SS# Shop Name
222-22-2222 Accounts Johnson
111-11-1111 Purchasing Smith
112-22-1122 Mechanics Bryant
000-00-0000 Accounts Jones

Anyone have any idea how I can match (combine) the “Shop†and “Name†columns
of Worksheet #2 with the corresponding SS#s of worksheet #1. Any help is
appreciated.

 

[Dave Peterson]

It looks like =vlookup() will do what you want.

Take a look at Debra Dalgleish's site for some nice instructions:
http://www.contextures.com/xlFunctions02.html