Help putting data in the correct column automatically

Mariann Carmen

Hello.

I'm working with a worksheet where I'm trying to put a Workers management team into the correct column based on the Managers Management Level. I'm able to see the flow of an organization by using an INDEX(MATCH()) formula (=INDEX({Manager}, MATCH(Worker@row, {Worker}), 1), but how do I get the data to show up in the correct column?

In the example below, the data highlighted should be showing up in the Vice President / ML3 columns.

Any help would be greatly appreciated.

Mariann Carmen

I feel like I need an additional piece of criteria in the Formula for it to know where to place the data when it's found.

Michelle Choate 2

You might need an INDEX/COLLECT formula to parse out multiple criteria to fill the columns.

Mariann Carmen

@Michelle Choate 2 Will you please give me an example on how to write this formula based on my example above? I've looked at the Formula, but I can't figure out how to use it correctly.