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