Hi,

You may refer to Question 9 on the following link -
http://ashishmathur.com/knowledgebaseII.aspx

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"jkiser" wrote in message
...
I have a workbook with a large number of worksheets; on each worksheet is
an
array of data. I'm creating a summary worksheet to sum all of the other
worksheets. The problem is that all of the worksheets aren't
aligned....the
data to be added is all in column "E" but on its on a different line on
every
sheet.

Each of the data lines does have a common identifier so that I can use the
V-lookup formula to find the data to be added, but with so many sheets, it
would be a very, very long formula.

Question, if I make all of the data arrays the same size, can I use the
Vlookup formula across multiple worksheets....if "yes", how?

If not Vlookup, is there another means to do it?

Thanks