Using google sheets, is there a way to look up a value on the vertical & horizontal axes between two numbers?
If years of service is 2.8 and company growth is 18.8, how can a lookup formula return 10%?
We are rounding down on both years of service & company growth.
Company growth: greater than equal to 10% & less than 20%; return in the 10% column.
Years of Service: greater than equal to 2 & less than 3; return in the 2-year row.
If years of service is 2.8 and company growth is 18.8, how can a lookup formula return 10%?
We are rounding down on both years of service & company growth.
Company growth: greater than equal to 10% & less than 20%; return in the 10% column.
Years of Service: greater than equal to 2 & less than 3; return in the 2-year row.
| Company Revenue Growth % | ||||
| Years of Service | 10% | 20% | 30% | 40% |
| 0 | 0% | 0% | 0% | 0% |
| 1 | 0% | 0% | 0% | 0% |
| 2 | 10% | 12% | 14% | 16% |
| 3 | 15% | 17% | 19% | 21% |
