Help

[Janine]

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.

 

[Sheeloo]

Suppose you have setup your numbers and account nos in Sheet 1 Col A & B

Assuming you want to enter your nos in Col C starting at C2
then in D2 enter
=IF(ISNA(VLOOKUP(C2,A:B,2,False),"",VLOOKUP(C2,A:B,2,False)))

and copy down...

Now when you enter a number which is in Col A you will get the name for that
in Col D

 

[Janine]

Sorry but I can't get it to work. It doesn't like the "" in the middle

 

[Sheeloo]

Sorry, I put the parenthesis in the wrong place...

Try
=IF(ISNA(VLOOKUP(C2,A:B,2,FALSE)),"",VLOOKUP(C2,A:B,2,FALSE))