# Issue in Index/Aggregate formula

1. ## Issue in Index/Aggregate formula

I am struggling with the following formula in that attached workbook

Under Summary tab, I have posted highlighted yellow the result I want from the drawing list and put the formula in a couple of lines below

=INDEX('Drawing list'!\$B:\$B,AGGREGATE(15,6,ROW('Drawing list'!\$B\$6:\$B\$
50))/(('Drawing list'!\$G\$6:\$G\$50=\$B8)*('Drawing list'!\$C\$6:\$C\$50=\$E8)*('Drawing list'!\$D\$6:\$D\$50=\$F8)*('Drawing list'!\$E\$6:\$E\$50=\$G8)),ROWS(D\$8:D8))

I have learnt such a formula here, but sometimes have to play around with it to get it to work, but this time no matter what I do I cant get it to work
I am presuming the error is in this section:

INDEX('Drawing list'!\$B:\$B,AGGREGATE(15,6,ROW('Drawing list'!\$B\$6:\$B\$750))/

I am never quite sure what the B:B and ('Drawing list'!\$B\$6:\$B\$750) are doing? Sso I never know till I get the result if I am using this section correctly - its a trial and error story! Can anyone explain what these sections are doing?  Register To Reply

2. ## Re: Issue in Index/Aggregate formula

Did 'Drawing No.' , 'Section' , 'Area/floor' and 'Plan or elev' is unique ?
If yes

D8 ``Please Login or Register  to view this content.``
H8 ``Please Login or Register  to view this content.``
Regards.  Register To Reply

3. ## Re: Issue in Index/Aggregate formula

Menem

I an not sure if I understand what you mean about "unique" but the formula's appear to work - at least for the drawings here - I had a few wobblies when I tried to take it to the actual spreadsheet - so I may need to come back to this!  Register To Reply