Formula

[awappel]

I have two worksheets, one with a list of account numbers and names and the other of account numbers and address. Is there a formulat that I can write on one of the worksheets to look at the account numbers on the other, and if they match, put the corresponding name into the field? I was playing with an if formula, but it got way to long and complicated.
Thanks in advance for any help.

 

[delaneyjm]

Take a look at the VLOOKUP formula.

 

[Aladin Akyurek]

I have two worksheets, one with a list of account numbers and names and the other of account numbers and address. Is there a formulat that I can write on one of the worksheets to look at the account numbers on the other, and if they match, put the corresponding name into the field? I was playing with an if formula, but it got way to long and complicated.
Thanks in advance for any help.

Try something lıke...

=INDEX(NameRange,MATCH(AccountNumber,AccountNumberRange,0))


_____________________
Post #3 from İstanbul...