Your values are 1000 times greater than the 322,000 number you gave as an
example; I presume you meant 322,000,000. Anyway, assuming all those figures
are actually numbers formatted to appear as you listed them, this formula
should do what you want...

=SUMPRODUCT((D1=A1:A13)*(D1<=B1:B13)*(C1:C13))

assuming your values are in A1:C13 and the value you are searching for is in
D1.

Rick


"tabian" wrote in message
...
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