Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations JAE on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sum multiple lookup table across worksheets

Status
Not open for further replies.

Jkaen

Chemical
Joined
Aug 1, 2003
Messages
43
Location
GB
Hey all, hope you can help me.

I am trying to get a framework contract tracking software sorted and have call in excel to try to obtain data from across various worksheets (circa 60)

The formula I am using for a single worksheet is:
{=INDEX('Sheet 2'!A8:I9,MATCH(A7&C7,'Sheet 2'!D8:D9&'Sheet 2'!E8:E9,0),9)}

(Note this is an array)

What I would like is to sum that value with:
{=INDEX('Sheet 3'!A8:I9,MATCH(A7&C7,'Sheet 3'!D8:D9&'Sheet 3'!E8:E9,0),9)}
{=INDEX('Sheet 4'!A8:I9,MATCH(A7&C7,'Sheet 4'!D8:D9&'Sheet 4'!E8:E9,0),9)}
all the way to
{=INDEX('Sheet 59'!A8:I9,MATCH(A7&C7,'Sheet 59'!D8:D9&'Sheet 59'!E8:E9,0),9)}

Does anybody know an elegant way of doing it?

Thanks
Stephen
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top