how do you setup a table

D

Daryl

I'm trying to create a database on sheet 2, say from 1-40 names. i would
like to type in a numeric number (lets say #8) into sheet 1 say G, 4: I
would like the name from sheet 2 posted from say #8 to be posted into cell G5?

How do i do this?

Also, is it possible to have the pop up window prompt me for the next data
entry?

thanks
 
G

Gord Dibben

Daryl

Sheet2 has two columns............

A1:A40 contains numbers 1-40

B1:B40 contains your 40 names.

In Sheet1 G5 enter this formula =VLOOKUP(G4,Sheet2!$A$1:$B$40,FALSE,0)

Type a number in G4 and G5 will be populated.

For more on VLOOKUPs and for the second question, see Debra Dalgleish's site.

Look for Data Validation Lists and VLOOKUP tables assistance.


Gord Dibben MS Excel MVP
 
G

Gord Dibben

Whoops!!

Missed/messed up a piece of formula............

=VLOOKUP(G4,Sheet2!$A$1:$B$40,2,FALSE)


Gord

Daryl

Sheet2 has two columns............

A1:A40 contains numbers 1-40

B1:B40 contains your 40 names.

In Sheet1 G5 enter this formula =VLOOKUP(G4,Sheet2!$A$1:$B$40,FALSE,0)

Type a number in G4 and G5 will be populated.

For more on VLOOKUPs and for the second question, see Debra Dalgleish's site.

Look for Data Validation Lists and VLOOKUP tables assistance.


Gord Dibben MS Excel MVP
Click to expand...

Gord Dibben MS Excel MVP
 
Top