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