Excel formula

E

entmjs

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.
 
S

Sloth

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
 
G

Gord Dibben

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
 
J

Jay

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),A1>0),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.
 
G

Gord Dibben

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
 
Top