Average VLookup over multiple sheets

**pjsilber** · 10-05-2011, 04:02 AM

Hello All-

I am new to the forum & excel but hopefully someone can assist.

I am trying to find average times by using VLOOKUP (or a better function) on a workbook of data which contains 31 separate tabs (1 for each day of the month)

My data is a list a flights and associated times with each flight.

I've attached an example.
**Please note, the example includes only 5 tabs (5 dates), while the true data set has 31 tabs. Also, not all flights operate everyday and the order of flights can change each day.

Thanks for any assistance,
Peter

**pjsilber** · 10-05-2011, 03:09 PM

Maybe I could use an AVERAGEIF Function over the multiple sheets. I'm looking to create a list of all flights with there associated averages pulling data from all sheets...

**NBVC** · 10-05-2011, 03:23 PM

Try, in B2:

Please Login or Register  to view this content.

adjust ranges to suit and the sheetnumber range and then confirm with CTRL+SHIFT+ENTER not just ENTER and copy down.

**pjsilber** · 10-05-2011, 07:15 PM

Thank you! That seems to work.
I'm really interested in learning more about excel functions. Any suggestions, aside from this forum, as to a good starting point for building on my excel knowledge?