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

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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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

Thanks David, How simple. Works great.



"Todd_Aus" wrote:

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