software

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

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

Thanks David, How simple. Works great.
quot;Todd_Ausquot; wrote:

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