how to make one colum respond to the next

[Uffe]

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

 

[Nick Hodge]

Uffe

You would set up the accounts on another sheet with the account numbers in
the first column. (You could either at this point use the range address in a
VLOOKUP function or name the range, (Edit>Name>Define), say Accounts)

On the sheet you want to put the data when typed use the VLOOKUP function so
if your account name for example is in D10 then you would enter this formula
(Presumes named range)

=IF(ISERROR(VLOOKUP(F10,Accounts,1,FALSE)),"",VLOOKUP(F10,Accounts,1,FALSE))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Jay]

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)

On a separate worksheet, you could make a two-column list of the account
numbers with the corresponding account names.

Then, use VLOOKUP()of the original worksheet to write the appropriate
account name in column D. Excel's built-in Help describes the VLOOKUP
function.