I need a formula that will look a table with 3 columns and 13 rows in which
the data is:
OE Metric SW List
0 34,999,999 $27,930
35,000,000 79,999,999 $45,486
80,000,000 99,999,999 $64,638
100,000,000 174,999,999 $79,800
175,000,000 234,999,999 $95,760
235,000,000 299,999,999 $112,518
300,000,000 374,999,999 $132,468
375,000,000 499,999,999 $165,186
500,000,000 599,999,999 $191,520
600,000,000 699,999,999 $217,854
700,000,000 899,999,999 $244,188
900,000,000 999,999,999 $296,856
1,000,000,000 9,999,999,999 $296,856

I have a value that I need to find where it is on this table and return the
information from column C. For instance, if the OE is 322,000, I need it to
return the value of $132,468.

thanks.
tina