I am trying to get lookup to find a cell and use the formula in the cell.
I have a lot of different formulas arranged in different cells. (Columns J, K, L)
it starts out with a coordinat set X and Y. First we need to figure out what interval X fits in.
Then we need to look at the three different formulas in columns J, K and L. Wich furmula is true for the coordinat set.
Finally we need it to return the sentence in J6, K6 or L6
For instance X=1.6 and Y=0.9
X fits with the interval in row 11 (H11)
then we need to figure out wich of the three formulas are true?
I’m trying to do this, so I only have to write the formulas in one place.
I can get the lookup to return a value in the right cell, but if I have a formula in that cell, I can’t figure out how to solve the formula.
I have a lot of coordinat sets.
Name: Udklip.PNG Views: 25 Size: 77.5 KB
Bookmarks