linking cells Help me

[Guest]

In one column (F10), I punch an account number (ex. 1999) I would then like
Excl to write the appropriate account name in the following column (D10)

HOW??


Perhaps you can also mail me your answer if you have a solution
([email protected])


Thanks in advance

 

[Frank Kabel]

Hi
sounds like VLOOKUP is the function you're looking for. See:
http://www.mvps.org/dmcritchie/excel/vlookup.htm