auto enter cell info like lotus
 

Is there a feature in excel that will auto enter data into another field in
another column? IE: I can enter the acct. #123 for fuel expense in lotus,
then credit the expense amount to bank. Lotus will then automatically enter
the amount again way over in the fuel expense column without having to scroll
over and do it manually.

Which function in excel can do this? What subject in the help covers this? I
would like to start using excel rather than lotus.
Thanks, Zed

Zed

Bit difficult to understand, but I think you are looking for VLOOKUP

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Zed" wrote in message
...
Is there a feature in excel that will auto enter data into another field
in
another column? IE: I can enter the acct. #123 for fuel expense in lotus,
then credit the expense amount to bank. Lotus will then automatically
enter
the amount again way over in the fuel expense column without having to
scroll
over and do it manually.

Which function in excel can do this? What subject in the help covers this?
I
would like to start using excel rather than lotus.
Thanks, Zed