Index Multiple Sheets

[rustymh]

Hi guys

Struggling a bit with this. Can someone please help with this formula. I Just need it to INDEX more than one sheet. Currently it works perfectly indexing sheet 06 into each persons tab but need to include 07 to 12 as well.

The formula (Sheet 06 Should be Sheets 06 to 12):

Please Login or Register  to view this content.

Please see Sample file I've created.

Annotation 2020-07-22 073524.png

[CRIMEDOG]

I added to Column G - in G1 the name Then in G2:G... formula

Please Login or Register  to view this content.

then in column A (starting A2)

Please Login or Register  to view this content.

add

Please Login or Register  to view this content.

for each tab changing the '06' to 07 08 09...
You can hide column G by changing text color

[rustymh]

Thank you for your input although it's not working

I've play around with your formula suggestion and here what I've found:

Keep in mind that the Job nr is not a date. Although in date format but the Job number can also go upto for example: 2020/07/150 or even Job001 for that matter. Those value gives #VALUE error.

Also what it's doing, it will bring in the first Index item and then from there it will only start counting +1 and increase the first Job number by +1 and not actually listing the correct Job number.

Although your formula will bring in the Job Number even if it's already listed, we can probably just use a filter not to show the duplicates, as I sum the values already through ShtList, so I think it can work eventually this way.

[CRIMEDOG]

Ok - How about this Leave the change to column G - then use:

Please Login or Register  to view this content.

[rustymh]

Fantastic, Thank you so much!! Maybe now I'll get a hang of these Index and Indirect Functions