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

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

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

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

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

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

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