| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lists- Simple Question
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lists- Simple Question
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lists- Simple Question
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lists- Simple Question
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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lists- Simple Question
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! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lists- Simple Question
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! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lists- Simple Question
How would I go about sending it? That would be great!!
"Sheeloo" wrote: 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! |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lists- Simple Question
Ok...now another problem...can i send this to you???
"Sheeloo" wrote: 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! |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lists- Simple Question
I don't know how I did it but I got it to work! THANK YOU!
"Sheeloo" wrote: 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! |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lists- Simple Question
Yes, pl. send it to me...
You can describe the problem in the mail or inside the file. click on my name in the post and you will see my id. just remove the first part after the @ sign... "GA85" wrote: Ok...now another problem...can i send this to you??? "Sheeloo" wrote: 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! |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lists- Simple Question
It has been sent!!
"Sheeloo" wrote: Yes, pl. send it to me... You can describe the problem in the mail or inside the file. click on my name in the post and you will see my id. just remove the first part after the @ sign... "GA85" wrote: Ok...now another problem...can i send this to you??? "Sheeloo" wrote: 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! |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lists- Simple Question
Updated file sent to you...
Here is the response... You were using =VLOOKUP($B$9,'Chart of Accounts'!A2:B40,2,FALSE) in C9 and copying it down. Since $B$9 implied 'Absolute Reference' it does not change to B11, B12, as it should. Also you used A2:B40 ('Relative Reference) which changed to A4:B42 when copied... You should use; ==VLOOKUP(B9,'Chart of Accounts'!$A$2:$B$40,2,FALSE) "GA85" wrote: It has been sent!! "Sheeloo" wrote: Yes, pl. send it to me... You can describe the problem in the mail or inside the file. click on my name in the post and you will see my id. just remove the first part after the @ sign... "GA85" wrote: Ok...now another problem...can i send this to you??? "Sheeloo" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
| simple Question | New Users to Excel | |||
| a very simple question | Excel Discussion (Misc queries) | |||
| Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
| Simple VBA question | Excel Discussion (Misc queries) | |||
Linear Mode
