Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need a Formula for a Database
Here is what i need.
I have a list of of one hundred (or More) 4 digit tracking codes that have a label (description) for each; for example 0234 is Hauling, 0142 is General Labor etc. I think what i want is a Database so when i input my 4 digit tracking code into cell 'A1', cell 'B1' will fill in the correct description and i won't have to type it anymore. I am guessing that i create a 'worksheet1' that has all the 4 digit tracking codes in Column 'A' and all their descriptions in Column 'B' On 'worksheet2' i would need a formula in the cells for Column 'B' that basically says (i think) - If 'Worksheet1' cell in column 'A' equals the tracking code entered in 'Worksheet2' cell 'A1' then insert 'worksheet1's appropriate Column 'B' description into 'Worksheet1' cell 'B1'. Please Help me!!! -- Jon Robershaw Wardell Builders, Inc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need a Formula for a Database
Hi,
That's exactly what you do, build a table out of the way along the lines of Col G Col H 1234 Some Text 5678 More text then when you enter your number in (say(a1) in an adjacent cell =IF(A1<"",VLOOKUP(A1,Sheet1!A1:B34,2,FALSE),"") Mike "JonWardellBuilders" wrote: Here is what i need. I have a list of of one hundred (or More) 4 digit tracking codes that have a label (description) for each; for example 0234 is Hauling, 0142 is General Labor etc. I think what i want is a Database so when i input my 4 digit tracking code into cell 'A1', cell 'B1' will fill in the correct description and i won't have to type it anymore. I am guessing that i create a 'worksheet1' that has all the 4 digit tracking codes in Column 'A' and all their descriptions in Column 'B' On 'worksheet2' i would need a formula in the cells for Column 'B' that basically says (i think) - If 'Worksheet1' cell in column 'A' equals the tracking code entered in 'Worksheet2' cell 'A1' then insert 'worksheet1's appropriate Column 'B' description into 'Worksheet1' cell 'B1'. Please Help me!!! -- Jon Robershaw Wardell Builders, Inc |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need a Formula for a Database
You could use the VLOOKUP function.
You would have a 2 column table with tracking codes and descriptions on another sheet in A1:B100 In Sheet1 B1 enter this formula =VLOOKUP(A1,Sheet2!$A$1:$B$100,2,FALSE) Enter a tracking code in A1 of Sheet1 You could also use a Data Validation drop-down list in Sheet1 A1 for selecting the tracking code. Visit Debra Dalgleish's site for info on VLOOKUP function to pull data based on value. Note the downloadable sample workbooks. http://www.contextures.on.ca/xlFunctions02.html Also see Debra's site for info on Data Validation selection lists for inputting the data if need be. http://www.contextures.on.ca/xlDataVal01.html Gord Dibben MS Excel MVP On Tue, 10 Jun 2008 10:56:03 -0700, JonWardellBuilders wrote: Here is what i need. I have a list of of one hundred (or More) 4 digit tracking codes that have a label (description) for each; for example 0234 is Hauling, 0142 is General Labor etc. I think what i want is a Database so when i input my 4 digit tracking code into cell 'A1', cell 'B1' will fill in the correct description and i won't have to type it anymore. I am guessing that i create a 'worksheet1' that has all the 4 digit tracking codes in Column 'A' and all their descriptions in Column 'B' On 'worksheet2' i would need a formula in the cells for Column 'B' that basically says (i think) - If 'Worksheet1' cell in column 'A' equals the tracking code entered in 'Worksheet2' cell 'A1' then insert 'worksheet1's appropriate Column 'B' description into 'Worksheet1' cell 'B1'. Please Help me!!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need a Formula for a Database
Awsome! i knew excel could do that!!
Thank you much -- Jon Robershaw Wardell Builders, Inc "Mike H" wrote: Hi, That's exactly what you do, build a table out of the way along the lines of Col G Col H 1234 Some Text 5678 More text then when you enter your number in (say(a1) in an adjacent cell =IF(A1<"",VLOOKUP(A1,Sheet1!A1:B34,2,FALSE),"") Mike "JonWardellBuilders" wrote: Here is what i need. I have a list of of one hundred (or More) 4 digit tracking codes that have a label (description) for each; for example 0234 is Hauling, 0142 is General Labor etc. I think what i want is a Database so when i input my 4 digit tracking code into cell 'A1', cell 'B1' will fill in the correct description and i won't have to type it anymore. I am guessing that i create a 'worksheet1' that has all the 4 digit tracking codes in Column 'A' and all their descriptions in Column 'B' On 'worksheet2' i would need a formula in the cells for Column 'B' that basically says (i think) - If 'Worksheet1' cell in column 'A' equals the tracking code entered in 'Worksheet2' cell 'A1' then insert 'worksheet1's appropriate Column 'B' description into 'Worksheet1' cell 'B1'. Please Help me!!! -- Jon Robershaw Wardell Builders, Inc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula for database search - is it possible? | Excel Discussion (Misc queries) | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
Help with database formula. | Excel Worksheet Functions | |||
Database Formula | Excel Discussion (Misc queries) | |||
DATABASE FORMULA | Excel Discussion (Misc queries) |