Index Match not returning desired value


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!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!