Hi, I'm new to excel, I apologize if this question is too basic. I work for
an accountant, and I have to enter an account purpose and the account number
for that purpose in a cell right next to it. Is there any way to enter the
purpose and make the set value of the account number appear next to it
automatically? For example if I enter ABC for purpose, can I make a (fake)
account number of 50-5025-02 appear next to it automatically? And the same
goes for other purposes and their respective account numbers.