Hi all, hoping someone might be able to help me out with this formula. What I have is a table like the one below. I can amend the values in the table (particularly the last column) to make the formula work.
I'm trying match the first column, first row and last column to specific cells, however, none of the numbers that I'm trying to match are exact matches. For example, one set of data looks like this:
So I need to recognize that cell C14 is equal to or greater than 1,000,000, Cell D14 is less than 30%, and cell E14 is greater than 10%, therefore the formula should return the value shown in cell D7.
Could someone help?
A | B | C | D | E | |
1 | 40% | 35% | 30% | ||
2 | $250,000 | 0.5% | 1.5% | 2.5% | <25% |
3 | $250,000 | 1.0% | 2.0% | 3.0% | >25% |
4 | $500,000 | 1.0% | 2.0% | 3.0% | <15% |
5 | $500,000 | 1.5% | 2.5% | 3.5% | >15% |
6 | $1,000,000 | 1.0% | 2.0% | 3.0% | <10% |
7 | $1,000,000 | 2.0% | 3.0% | 4.0% | >10% |
I'm trying match the first column, first row and last column to specific cells, however, none of the numbers that I'm trying to match are exact matches. For example, one set of data looks like this:
C | D | E | |
14 | $1,962,939.84 | 16.8% | 23.65% |
So I need to recognize that cell C14 is equal to or greater than 1,000,000, Cell D14 is less than 30%, and cell E14 is greater than 10%, therefore the formula should return the value shown in cell D7.
Could someone help?