Index and Match Excel Question.

[DNapoli]

Tab1 "01.31.2021" has a "Total" line in column B. I want to return the values in columns C, D, E ,F,G, and H from the "Total Line" in my second tab.
Tab2 "Metrics V3" starts in column L 17 and goes down. I want to populate the totals from the 1st sheet into the 2nd sheet (Metrics V3)
My formula does not drag down in the 2nd sheet. I had to edit it to get it to work manually. What am I doing incorrectly?
=INDEX('01.31.2021'!$C:$H, MATCH("Total", '01.31.2021'!$B:$B, 0) + ROW() - ROW($L$17), COLUMN() - COLUMN($L$17) + 1)
=INDEX('01.31.2021'!$C:$H, MATCH("Total", '01.31.2021'!$B:$B, 0) + ROW(L18) - ROW($L$18), COLUMN() - COLUMN($L$18) + 2)
=INDEX('01.31.2021'!$C:$H, MATCH("Total", '01.31.2021'!$B:$B, 0) + ROW(L19) - ROW($L$19), COLUMN() - COLUMN($L$19) + 3)
View attachment 108883

01.31.2021 Tab

Metrics V3 Tab

 

[DNapoli]

@DNapoli
Please confirm that this is a Google Sheets question, not a Microsoft Excel question.

This is Excel. Apologies as I had opened it in Google Sheets.

 

[DNapoli]

I think Sheets may be interpreting your 01.31.2021 entry in cell C14 as a date, which will be treated as a number, and that won't match the text name of your worksheet. Try editing C14 to force it to text by adding a ' (a single apostrophe) before the rest of the entry, as in '01.31.2021

I tried this and now get a #Name? Error.

 

[DNapoli]

What is the G22 that appears in that screen snapshot where the formula is shown? And is the sheet named 01.31.2021 exactly?

Thank you, I saw that but did not see my formula had that in there. I fixed it but still having an issue.

 

[KRice]

Just to confirm, are you using Excel 365? The formula uses functions that wouldn't be recognized by older versions of Excel. And let's review your current layout, as I can't see some details. C14 is the worksheet name to reference 01.31.2021. The formula is in which cell now?

 

[Peter_SSs]

This is Excel.

OK, thanks.
In that case can you post some small sample data with XL2BB?
We cannot tell much from an image, cannot copy from it and in any case there would be a lot of manual typing to try to replicate what you have.