INDEX/MATCH I'm trying to match the Branches names

System

This discussion was created from comments split from: Index/Match vs. Index/Collect?.

TBurnett

@Paul Newcome I've been hunting for this explanation and reading your response has unfortunately not helped. I'm trying to do the same thing. You commented on a question I asked poorly earlier, so I think seeing this example should help achieve to the solution I'm hunting for. I need to take the All Projects column and move it just like above. I'm not trying to match 1's though, I'm trying to match the Branches names. The BR01: xxxxxx information.

What can I do to make this work for me?

Paul Newcome

@TBurnett I'm not sure I follow.

TBurnett

In the thread this comment was originally on, the requestor was compiling prices dependent upon the matching months and putting it on a separate sheet. The formula was also drag-able. I'm needing to do virtually the same thing with different column data. I'm trying to compile project types {2024 All Projects} from a branch {2024 Branches} on the new sheet.

I've tried this and get #invalid value:

=INDEX({2024 All Projects}, MATCH(Branches@row, {2024 Branches}, 0), 21)

I tried this and get #No Match:

=MATCH(Branches@row, {2024 Branches}, 1)

I made this based off of your response to the previous thread and I got #Incorrect Argument Set:

=IFERROR(INDEX(COLLECT({2024 All Projects}, {2024 Branches}, Branches@row = {2024 Branches})), "")

This is the target sheet. The screenshot above is what I'm trying to pull from.