Vlookup with non matching data

[Guest]

I have two columns of numbers. The value i am trying to lookup is not an
exact match but will between the values of the numbers in the two columns on
adjacent rows, I wish to return the value of a third column. Approx 30 rows
of data. I have used nested If statements before but can only nest 7
statements.
Eg
A 1 10
B 11 20
C 21 30
D 31 40
etc

Wish to say lookup 25 and thus return value of C.
Anybody help.

Thanks

 

[David McRitchie]

Hi Todd,
Use column B as the first column in your VLOOKUP then you pick up the grade
http://www.mvps.org/dmcritchie/excel/vlookup.htm

 

[Guest]

Thanks David, How simple. Works great.