# In a summary sheet return a location wise values in number of each equipment quantity

1. ## In a summary sheet return a location wise values in number of each equipment quantity

Hi,

Required a formula help to in a summary sheet return a location wise values in number of each equipment quantity from as based on date wise various sheets.

Sample results (highlighted area) are enclosed for the reference.

Thanks,

2. ## Re: In a summary sheet return a location wise values in number of each equipment quantity

1. Make sure that the location spellings are IDENTICAL. they weren't.

2. Paste this formula into the top left of each shaded block, and change the bits in red appropriately.

=INDEX(INDIRECT("'"&TEXT(\$B\$2,"dd.mm")&"'!B6:E10"),MATCH(\$A6,INDIRECT("'"&TEXT(\$B\$2,"dd.mm")&"'!A6:A10"),0),MATCH(\$B\$3,INDIRECT("'"&TEXT(\$B\$2,"dd.mm")&"'!B3:E3"),0)+COLUMNS(\$B6:B6)-1)
3. Copy across and down.

4. Done for all four blocks in the sample.

3. ## Re: In a summary sheet return a location wise values in number of each equipment quantity

Many thanks glenn for the formula solution.

There are currently 1 users browsing this thread. (0 members and 1 guests)