Data Entry

[Datagirl]

I have a very large amount of data to enter and would like to make the process as painless as possible. A lot of my entries are repetitive and already have a numerical value assigned to them for statistical analysis later. What I would like to do is be able to enter in a number in one column and have the corresponding word automatically enter into the next column. For example, I have collected data from 10 different magazines and each magazine is assigned a number (1 through 10). I would like to be able to enter 1 in column 1 and have Atlantic Monthly (the corresponding words) appear in column 2. Is there any formula to do this?

Thanks!!!

[NBVC]

You can use a Lookup() function....

if you have the list of magazines in a separate table, with the first column in ascending order from 1 to 10, then, assuming this list in X1:Y10, for example, use:

=Lookup(A1,$X$1:$Y$10) where A1 is the number you enter.