Index/Match Help

I have trying to create a formula so when we purchase materials which will be logged on my order list sheet, for a job using the Job reference from my job planner sheet. It will calculate the running cost of materials and bring it back to the material value column on my Planner.

I have been trying the below formula but this only picks up 1 row for when the Job reference is used, for example, we could purchase materials multiple times for one job reference so i am trying to have it work so when it matches a job reference of a full column, it will pick up the value and calculate.


=INDEX({[Cross sheet reference Materials Value column}, MATCH([Job reference]@row, {Cross sheet reference Job column},0))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!