auto enter cell info like lotus

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
(e-mail address removed)
 
Back
Top