I have the following table, 3 columns:
<TBODY>
</TBODY>
Then I have a number of numerical values in another column, such as below:
<TBODY>
</TBODY>
I want to be able to lookup the values listed just above here, and lookup which ranges they fall into with my first table up top of this post, and return the value in the "Priority Level" column for that range it falls in.
I want my formula to check the first table by cell references rather than the numerical values, that way if I ever update my table of ranges/priority levels, the formula doesn't need adjusted.
Can someone help me put that into a formula?
Low End | High End | Priority Level |
prospects | $0 | |
$1 | $499 | 1 |
$500 | $999 | 2 |
$1,000 | $1,999 | 3 |
$2,000 | $2,999 | 4 |
$3,000 | $4,999 | 5 |
$5,000 | $9,999 | 6 |
$10,000 | $14,999 | 7 |
$15,000 | $29,999 | 8 |
$30,000 | $99,999 | 9 |
$100,000 | + | 10 |
<TBODY>
</TBODY>
Then I have a number of numerical values in another column, such as below:
$37,686.95 |
$37,590.34 |
$36,183.91 |
$33,878.85 |
$30,264.94 |
$28,492.51 |
$27,903.74 |
$26,777.97 |
$25,964.11 |
<TBODY>
</TBODY>
I want to be able to lookup the values listed just above here, and lookup which ranges they fall into with my first table up top of this post, and return the value in the "Priority Level" column for that range it falls in.
I want my formula to check the first table by cell references rather than the numerical values, that way if I ever update my table of ranges/priority levels, the formula doesn't need adjusted.
Can someone help me put that into a formula?