Looking up a value in a sheet



I m looking at filling sheet2 below using lookup formulas and reading data from sheet1. So, the "value" column in sheet2 should be a formula, getting for each team the value related to that specific category.

Hope this is clear. Please let me know if this can be done, i am not sure if it is simple i just cant make it work.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!