Need a formula to check a table with low ends and high ends in seperate columns, scores in another column, and return the score based on where the loo

[freeb1893]

I have the following table, 3 columns:

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?

 

[RonB1111]

Suggest you change the $1 in A3 to 0, since this formula looks up based on Col A. If your numerical values begin in F1, enter this formula in G1 and copy down:

=VLOOKUP(F1,$A$3:$C$12,3,TRUE)