Hi guys,
I have a question that I'm trying to find a solution for and I+m having trouble finding it.
On a spreadsheet I have, I have a table and on line 1 I have a few formulas that work fine (one formula for each row. Row 1 it's text, Row 2 I use lookup formula to look for a string and Sum all the numbers associated with that string, Row 3 percentage calculation)
When I create a second row, and change a few criteria on the formulas (only the term to be searched), it unexpectedly, also changes row 1. for the same criteria
On row 1 I want ti to search for school and on row 2 I want to to search for teachers
I have a question that I'm trying to find a solution for and I+m having trouble finding it.
On a spreadsheet I have, I have a table and on line 1 I have a few formulas that work fine (one formula for each row. Row 1 it's text, Row 2 I use lookup formula to look for a string and Sum all the numbers associated with that string, Row 3 percentage calculation)
When I create a second row, and change a few criteria on the formulas (only the term to be searched), it unexpectedly, also changes row 1. for the same criteria
On row 1 I want ti to search for school and on row 2 I want to to search for teachers