INDEX/MATCH works in one sheet, same formula gives #INVALID OPERATION in another

Laura CB

Hi all

I have a Project Info section of my schedule sheet that I pull into columns so that the info can be used in automated emails about tasks. The sheet that's giving me problems is a copy of another sheet, where the formula works.

=INDEX([Task Description]:[Task Description], MATCH("Portfolio", Task:Task, 0))

It works just fine in the original sheet and other sheets that are a copy of that one, but for some reason in this one it's throwing an #INVALID OPERATION error. The Task Description in the working sheets is linked to the Planning sheet as well, and it still throws an error for the Component row, which is not linked to anything. All columns are formatted as text/number.

Thanks in advance for any help!