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