software

I have a report that is prepared quarterly in excel, and the database is over
2500 rows of info. One column numbers( accounting number) changes quarterly
and has to be entered manually, which takes forever. I can create a new
report(excel file 2) that contains the unit number and the accounting number.
The common denominator in both report is the unit number.
Is there a way of importing the numbers from excel file 2 to excel file 1 by
looking up the unit number in file 2, pick the numbers to the right and
entering it in excel file 1 to the right of the same unit number?

Depending on how your data is laid out, maybe =vlookup() or =index(match())
would work:

You may want to read Debra Dalgleish's notes:
www.contextures.com/xlFunctions02.html (for =vlookup())
and
www.contextures.com/xlFunctions03.html (for =index(match()))Viggoros wrote:
gt;
gt; I have a report that is prepared quarterly in excel, and the database is over
gt; 2500 rows of info. One column numbers( accounting number) changes quarterly
gt; and has to be entered manually, which takes forever. I can create a new
gt; report(excel file 2) that contains the unit number and the accounting number.
gt; The common denominator in both report is the unit number.
gt; Is there a way of importing the numbers from excel file 2 to excel file 1 by
gt; looking up the unit number in file 2, pick the numbers to the right and
gt; entering it in excel file 1 to the right of the same unit number?

--

Dave Peterson