Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Look up/math text | Excel Worksheet Functions | |||
Totals of calculated field in pivot table give incorrect results | Excel Worksheet Functions | |||
Incorrect totals in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Tables, Help? | Excel Discussion (Misc queries) |