Looking up a value in a sheet

Options

Hello

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.








Thanks

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!