auto enter cell info like lotus

Z

Zed

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
 
N

Nick Hodge

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top