I keep running into issues in one of my SS environments where the Index Match function is returning a #NO MATCH. What's interesting is I will have it in one column in a sheet and it works, then in the next column I am using the same formula but the only difference is I am changing the INDEX range which then produces a NO MATCH. This doesn't make sense to me since it's working on the first one.
In another scenario, I am using the Index/Match in a column formula and it works in one row but not the next when I am literally copying and pasting the value to match to from the sheet I am looking at.
Any ideas why this could be occurring?
Here is the formula I use:
=INDEX({Program}, MATCH([Project Name]@row, {Intake Project Name}), 0)
