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
Check out the Formula Handbook template!