Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |