import excel data into existing excel report

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:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))





Viggoros wrote:
>
> 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?

--

Dave Peterson