#INVALID VALUE on index and match function

I am using an index and match function to show how much weight someone has lost each week. I was able to get the values for Week 1, but I cannot produce beyond that. I am copying over the formula and it is still pulling based off of name and week number but getting #INVALID VALUE.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!