how do you setup a table
 

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

how do you setup a table
 

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

On Mon, 17 Apr 2006 14:30:01 -0700, Daryl
wrote:

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

how do you setup a table
 

Whoops!!

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

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


Gord

On Mon, 17 Apr 2006 15:51:17 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

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

On Mon, 17 Apr 2006 14:30:01 -0700, Daryl
wrote:

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

Gord Dibben MS Excel MVP