Help
 

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

Help
 

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" wrote:

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

Help
 

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


"Sheeloo" wrote:

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" wrote:

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

Help
 

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

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


"Sheeloo" wrote:

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" wrote:

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