I have a drop-down list created with my account numbers. When I select an
account number from the drop-down list, I would like for the account name to
appear in the cell to the right of the cell with the account number. Any help
would be great! THANK YOU!

Use VLOOKUP
Assuming your drop down is in A1 in sheet 1 and your account no and names
data is in Sheet 2, COl A & B
then enter this in B1 of sheet 1;
=VLOOKUP(A1,Sheet2!A:B,2,FALSE)

"GA85" wrote:

I have a drop-down list created with my account numbers. When I select an
account number from the drop-down list, I would like for the account name to
appear in the cell to the right of the cell with the account number. Any help
would be great! THANK YOU!

That is not working :-(

Sheet1
A B
1101 Cash
1102 Accounts Recievable

Sheet2
A B
1101 This is where I want the name from col. B of sheet 1 to display


"Sheeloo" wrote:

Use VLOOKUP
Assuming your drop down is in A1 in sheet 1 and your account no and names
data is in Sheet 2, COl A & B
then enter this in B1 of sheet 1;
=VLOOKUP(A1,Sheet2!A:B,2,FALSE)

"GA85" wrote:

I have a drop-down list created with my account numbers. When I select an
account number from the drop-down list, I would like for the account name to
appear in the cell to the right of the cell with the account number. Any help
would be great! THANK YOU!

Enter this in B1 on Sheet 2
then enter this in B1 of sheet 1;
=VLOOKUP(A1,Sheet1!A:B,2,FALSE)

You may have to hit F9 to force recalculation.

"GA85" wrote:

That is not working :-(

Sheet1
A B
1101 Cash
1102 Accounts Recievable

Sheet2
A B
1101 This is where I want the name from col. B of sheet 1 to display


"Sheeloo" wrote:

Use VLOOKUP
Assuming your drop down is in A1 in sheet 1 and your account no and names
data is in Sheet 2, COl A & B
then enter this in B1 of sheet 1;
=VLOOKUP(A1,Sheet2!A:B,2,FALSE)

"GA85" wrote:

I have a drop-down list created with my account numbers. When I select an
account number from the drop-down list, I would like for the account name to
appear in the cell to the right of the cell with the account number. Any help
would be great! THANK YOU!

Still not working. Is there a simple way to accomplish this???

"Sheeloo" wrote:

Enter this in B1 on Sheet 2
then enter this in B1 of sheet 1;
=VLOOKUP(A1,Sheet1!A:B,2,FALSE)

You may have to hit F9 to force recalculation.

"GA85" wrote:

That is not working :-(

Sheet1
A B
1101 Cash
1102 Accounts Recievable

Sheet2
A B
1101 This is where I want the name from col. B of sheet 1 to display


"Sheeloo" wrote:

Use VLOOKUP
Assuming your drop down is in A1 in sheet 1 and your account no and names
data is in Sheet 2, COl A & B
then enter this in B1 of sheet 1;
=VLOOKUP(A1,Sheet2!A:B,2,FALSE)

"GA85" wrote:

I have a drop-down list created with my account numbers. When I select an
account number from the drop-down list, I would like for the account name to
appear in the cell to the right of the cell with the account number. Any help
would be great! THANK YOU!

It should...

What is the result you are getting where you are entering the formula?

Can you send the file to me?

"GA85" wrote:

Still not working. Is there a simple way to accomplish this???

"Sheeloo" wrote:

Enter this in B1 on Sheet 2
then enter this in B1 of sheet 1;
=VLOOKUP(A1,Sheet1!A:B,2,FALSE)

You may have to hit F9 to force recalculation.

"GA85" wrote:

That is not working :-(

Sheet1
A B
1101 Cash
1102 Accounts Recievable

Sheet2
A B
1101 This is where I want the name from col. B of sheet 1 to display


"Sheeloo" wrote:

Use VLOOKUP
Assuming your drop down is in A1 in sheet 1 and your account no and names
data is in Sheet 2, COl A & B
then enter this in B1 of sheet 1;
=VLOOKUP(A1,Sheet2!A:B,2,FALSE)

"GA85" wrote:

I have a drop-down list created with my account numbers. When I select an
account number from the drop-down list, I would like for the account name to
appear in the cell to the right of the cell with the account number. Any help
would be great! THANK YOU!