Numbers matchup

[Paul McGuire]

I have a column of Account numbers in one worksheet. In another worksheet i
have a column with account numbers and a column with SSN. I need a formula
that will take the account number in the first worksheet and find it's match
in the second worksheet and plug in the SSN on that same row as the Account
number.

Is this possible and how would be the best way to do this

TIA

Paul

 

[Don Guillett]

Have a look in HELP index for VLOOKUP

 

[Dave Peterson]

Maybe =vlookup() or =index(match()).

Visit Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html
and
http://www.contextures.com/xlFunctions03.html

for some nice instructions.