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,
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,
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.
Last edited by Glenn Kennedy; 04-17-2021 at 03:14 AM.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Many thanks glenn for the formula solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks