I am trying to use an index match formula that references a range of cells on another tab, but cant seem to get the syntax right. See the attached example.
I want to index Column C on the Projects tab with a Code on the Summary Tab to return the amount in column D (shaded yellow) for the respective Code.
I am trying to make an example without actual data. I am trurning values, but they are for the incorrect amounts so I figured it might be better if I just start over.
Here is the prodcution formula i was using that returns incorrect totals :=INDEX(Projects!$U$10:$U$