<<Another VLookup Question>>

[Scooterdog]

I will try to give a example of what I need:
a b c
1 0-80 195 55
2 81-100 200
3 101-150 250
I need to have VLookup (or some other function) find the
number 55 located in cell c1 and give the answer in b1.
Is this possible using vlookup? Thanks for your time.

 

[Don Guillett]

Look in HELP index for MATCH function to find the row in column C. Then,
look for INDEX to see how to use the row you found to find one column to the
left.

 

[Frank Kabel]

Hi
try the following:
- first use only the lower boundary in column A. thats is something
like:
A B
1 0 195
2 81 200
3 101 250

now use the following formula in C1
=INDEX(B1:B10,MATCH(C1,A1:A10,1))