So I have a formula =IF(CI128=CI125,MAX(CF114:CH114),IF(CI128=CI124,MEDIAN(CF114:CH114),IF(CI128=CI123,MIN(CF114:CH114)))) and it brings me back a number from a cell either CF114, CG114 OR CH114 depending which cell CI128 matches with, My question is I don't actually want it to bring CF114, CG114, OR CH114, I want it to bring the text from the cell directly above it.
So below is my sheet sorry I don't know how to do the mini sheets to make it easier The Red text cell has the formula in it and the formula brings back the number 165.76 from the cell with the blue text, But I actually want where the red text is to say "Urea" from the cell directly above the blue text cell, thanks in advance if anyone can help me out
So below is my sheet sorry I don't know how to do the mini sheets to make it easier The Red text cell has the formula in it and the formula brings back the number 165.76 from the cell with the blue text, But I actually want where the red text is to say "Urea" from the cell directly above the blue text cell, thanks in advance if anyone can help me out
| HRSW | By Stubble | |||
| Urea | 11-52 | Seed | ||
| Tank Split | 165.76 | 40.00 | 120.00 | |
| Seed rate | ||||
| Option 6 | 349.00 | 331.00 | 324.00 | |
| Option 7 | 511.00 | 331.00 | 162.00 | |
| Option 8 | 493.00 | 349.00 | 162.00 | |
| Option 9 | 680.00 | 162.00 | 162.00 | |
| Acres | ||||
126.33 | 165.50 | 486.00 | 126.33 | |
184.97 | 165.50 | 243.00 | 165.50 | |
178.45 | 174.50 | 243.00 | 174.50 | |
246.14 | 81.00 | 243.00 | 81.00 | |
174.50 | ||||
| Most Efficient | Tank 1 | Tank 2 | Tank 3 | Tank 4 |
165.76 | Seed | Urea | 11-52 | |
331.00 | 162.00 | 162.00 | 349.00 |
