|
Excel 2007
I have a list numbers with set values. For instance:
0 = 123 1 = 456 2 = 789 If I enter a 0 into cell A1, I want 123 to automatically be entered into B1; If I enter a 1 into cell A1, I want 456 to automatically be entered into B1; If I enter a 2 into cell A1, I want 789 to automataically be entered into B1 Thanks for your help! DiDi |
Excel 2007
Try: =Choose(A1+1,123,456,789) or if you have a list, say in X1:Y3 =Lookup(A1,X1:Y3) -- NBVC Where there is a will there are many ways. ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109445 |
Excel 2007
NBVC
I'm not understanding. In sheet 1, cell A1 -- If I type a 0, I want 123 to be automatically entered into Sheet 1, cell B1; if I enter a 1, I want 456 to be automatically entered into Sheet 1, cell B1. In sheet 2, I have typed a list: 0 = 123 2=456 3=789 Does that make sense? Di "NBVC" wrote: Try: =Choose(A1+1,123,456,789) or if you have a list, say in X1:Y3 =Lookup(A1,X1:Y3) -- NBVC Where there is a will there are many ways. ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109445 |
Excel 2007
Suppose you have the below list in Sheet2 ColA and ColB starting from Row1
ColA-ColB 0---123 2---456 3---789 In Sheet1 B1 enter the below formula (all in one line) =IF(ISERROR(MATCH(A1,Sheet2!A1:A100,0)),"",INDEX(S heet2!B1:B100,MATCH(A1,Sheet2!A1:A100,0))) If this post helps click Yes --------------- Jacob Skaria "Di_W" wrote: NBVC I'm not understanding. In sheet 1, cell A1 -- If I type a 0, I want 123 to be automatically entered into Sheet 1, cell B1; if I enter a 1, I want 456 to be automatically entered into Sheet 1, cell B1. In sheet 2, I have typed a list: 0 = 123 2=456 3=789 Does that make sense? Di "NBVC" wrote: Try: =Choose(A1+1,123,456,789) or if you have a list, say in X1:Y3 =Lookup(A1,X1:Y3) -- NBVC Where there is a will there are many ways. ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109445 |
Excel 2007
Di_W;391641 Wrote: NBVC I'm not understanding. In sheet 1, cell A1 -- If I type a 0, I want 123 to be automatically entered into Sheet 1, cell B1; if I enter a 1, I want 456 to be automatically entered into Sheet 1, cell B1. In sheet 2, I have typed a list: 0 = 123 2=456 3=789 Does that make sense? Di "NBVC" wrote: Try: =Choose(A1+1,123,456,789) or if you have a list, say in X1:Y3 =Lookup(A1,X1:Y3) -- NBVC Where there is a will there are many ways. ------------------------------------------------------------------------ NBVC's Profile: 'The Code Cage Forums - View Profile: NBVC' (http://www.thecodecage.com/forumz/member.php?userid=74) View this thread: 'Excel 2007 - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...d.php?t=109445) If your list in Sheet 2 is in A1:B3, then in B1 of your active sheet... try: =Lookup(A1,'Sheet2'!A1:B3) You will need to change the sheetname and range if they are different than in my formula. -- NBVC Where there is a will there are many ways. ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109445 |
Excel 2007
NBVC
Yes! This is very close to what I'm looking for. I want to be able to type into Sheet 1 cell A25 any one of the numbers in Sheet 2 cells A2-A11 (i.e. 0, 1, 2, 3, 4, 5, etc); with the corresponding data to automatically insert into Sheet 1 cells B25-B34. Example: SHEET 1 SHEET 2 -Data Row/Col A B Row/Col A B 25 3 343 2 0 316 26 5 356 3 1 327 27 9 376 4 2 335 28 7 367 5 3 343 29 8 372 6 4 350 30 5 356 7 5 356 31 0 316 8 6 362 32 2 335 9 7 367 33 6 362 10 8 372 34 7 367 11 9 376 Thank you so much for your help. Diane "NBVC" wrote: Di_W;391641 Wrote: NBVC I'm not understanding. In sheet 1, cell A1 -- If I type a 0, I want 123 to be automatically entered into Sheet 1, cell B1; if I enter a 1, I want 456 to be automatically entered into Sheet 1, cell B1. In sheet 2, I have typed a list: 0 = 123 2=456 3=789 Does that make sense? Di "NBVC" wrote: Try: =Choose(A1+1,123,456,789) or if you have a list, say in X1:Y3 =Lookup(A1,X1:Y3) -- NBVC Where there is a will there are many ways. ------------------------------------------------------------------------ NBVC's Profile: 'The Code Cage Forums - View Profile: NBVC' (http://www.thecodecage.com/forumz/member.php?userid=74) View this thread: 'Excel 2007 - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...d.php?t=109445) If your list in Sheet 2 is in A1:B3, then in B1 of your active sheet... try: =Lookup(A1,'Sheet2'!A1:B3) You will need to change the sheetname and range if they are different than in my formula. -- NBVC Where there is a will there are many ways. ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109445 |
Excel 2007
So in B25 of Sheet1, enter =Lookup(A2,Sheet2!$B$25:$B$34) and then fill down the formula to B34 of Sheet1 -- NBVC Where there is a will there are many ways. 'The Code Cage' (http;//www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109445 |
| All times are GMT +1. The time now is 12:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com