That answers one question. Are you looking for a SUMMATION sheet for each
account? For example, I have account number 12345, it happens to be in 25 of
the 40 departments (and therefore on 25 different tabs), are you looking for
the total for that account for all departmens? Or is your summation sheet
more along the lines of, I have an account, and I need to know that account
amount for a specific department.
I have a feeling it is the former, in which case, Teethless' suggestion
might be your best move.
--
** John C **


"jedman" wrote:

I have 40 departments all on separate workbooks. They have the same chart of
accounts but not every department uses all of the accounts. I want my
consolidated sheet to find the account number on each workbook and sum them
to give me a consolidated total. Is this even possible?

"franciz" wrote:

would you elaborate more?
In which Sheet are your lookup value?
Where will be your table arrays and which column do you want to return the
value?
Are your tables in your other sheets identical?

"jedman" wrote:

I am trying to use the vlookup to look at account numbers over 40 worksheets,
Is this possible to have the formula look in each worksheet without having to
type 40 different vlookups? I tried naming the range on each worksheet and
that is not working