Excel formula
 

I want to have a list sheet 2. But in sheet 1, when I type in the number I
want the name in the cell in sheet 2 to automatically come in. Please help.

I think I understand you correctly. You want the VLOOKUP function. Here is
an example on how to use it. Hope this helps.

Sheet2:
A1:1
A2:2
A3:3
B1:Red
B2:Blue
B3:Yello

Sheet1:
A1:2
B2:=VLOOKUP(A1,Sheet2!A1:B3,2)

B2 will output: Blue

"entmjs" wrote:

I want to have a list sheet 2. But in sheet 1, when I type in the number I
want the name in the cell in sheet 2 to automatically come in. Please help.

In sheet 2 cell A1 enter ='sheet 1'!A1

Whatever you type into A1 on sheet 1 will be entered on sheet 2.

Drag/copy this formula down column A as far as you wish.


Gord Dibben Excel MVP

On Thu, 29 Sep 2005 14:40:05 -0700, entmjs
wrote:

I want to have a list sheet 2. But in sheet 1, when I type in the number I
want the name in the cell in sheet 2 to automatically come in. Please help.

I want to have a list sheet 2. But in sheet 1, when I type in the
number I want the name in the cell in sheet 2 to automatically come
in.

One way is put this formula in B1 of sheet 1:
=IF(AND(ISNUMBER(A1),A10),INDIRECT("Sheet2!A"&A1) ,"---")

Then type the number in A1 of sheet 1.

This is assuming that the list is in column A of sheet 2.

Ignore first post.

Probably a VLOOKUP formula will do the trick.

Table on sheet 2 and lookup value in A1 on sheet 1 with VLOOKUP formula in B1
on sheet 1 or similar.

See Sloth's post for more detauled instructions.

Gord

On Thu, 29 Sep 2005 15:34:54 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

In sheet 2 cell A1 enter ='sheet 1'!A1

Whatever you type into A1 on sheet 1 will be entered on sheet 2.

Drag/copy this formula down column A as far as you wish.


Gord Dibben Excel MVP

On Thu, 29 Sep 2005 14:40:05 -0700, entmjs
wrote:

I want to have a list sheet 2. But in sheet 1, when I type in the number I
want the name in the cell in sheet 2 to automatically come in. Please help.