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