Index Match not returning desired value

Nichole Pyle

Hello, I am trying to pull information from one sheet into another using a "Dept ID" as the key. I've done this several times but for some reason, the formula is returning data from the wrong columns, and I can't figure out what is wrong.

Current Formula: =INDEX({Department Operations Portfolio}, MATCH($[Dept ID]@row, {Dept ID}, 0), MATCH(Name$1, {Department Operations Header Row}, 0))

Department Operations Sheet

Project Data Sheet - Where the formula is. Notice it's pulling the 'Sponsor' input into the 'Name' column.

Thanks for any help you can provide!

Paul Newcome

Double check your ranges. The {Header} should only cover the columns selected in the {Portfolio} range.

Paul Newcome

Double check your ranges. The {Header} should only cover the columns selected in the {Portfolio} range.

Nichole Pyle

That worked, thank you very much!

Paul Newcome

Happy to help. 👍️