I have set up account numbers with account names beside them..e.g. column A
is the account number and column B is the account name.
A B
1 40 n smith
2 41 t jones
3 42 p shaw

When I am entering data into spreadsheet I want to be able to just type in
the account no (40,41,42) in one column and have the account name appear in
the column next to it, so that I don't have to type in each name.
--
Thanks