You want Vlookup, as in:
=vlookup(f20,a1:c10,3,true)

Regards,
Fred

"cinnie" wrote in message
...
Hello to all

I have worked with functions in other programs, but I am totally new to
Excel. Here's my situation - I have a table like the following that
extends
for 10 rows.

A B C
1 0 50 700
2 50 100 1600
3 100 150 2500
4 150 200 3400
etc...

F G
20 174 =???



I want a function in cell G20 that takes the value in F20 (in this
example,
174), then determines what range that number falls in in columns A & B (in
this case, 174 is between A4 and B4), then returns the corresponding value
from C4 (in this case, 3400). I should mention as well that the range A4
to
B4, for example, means greater than or equal to A4, but strictly less than
B4.

Much thanks for any help!
--
cinnie