Looking up a value in a sheet
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

Hi Joelle,
It sounds like you're describing an INDEX/MATCH formula using cross sheet references. Here are some relevant help articles which I think will get you started implementing this kind of formula.
 Formula combinations for cross sheet references
 Create cross sheet references to work with data in another sheet
 Use column formulas to apply calculations to all rows in a sheet
 Advanced Crosssheet Formulas
Hope this helps!
Sal

thank you Sal i use formulas for quite some time but couldn't find the right formula for this.
It is working now with adding the column name as a helper row.
Help Article Resources
Categories
Check out the Formula Handbook template!