J
JonWardellBuilders
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!!!
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!!!