Assuming the source lookup table is in A1:C3,
lookup value (eg: 8) in E1

Place in F1, array-enter (press Ctrl+Shift+Enter to confirm the formula):
=INDEX(C1:C3,MATCH(1,(E1=A1:A3)*(E1<=B1:B3),0))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"saintsalive" wrote:
I need to lookup a value in a table, using the first 2 columns as a range,
then return the approp value from the 3rd column. For example lookup 8, as it
falls between 7 and 9, I want to return e. 18 would give me m as would 25.
col1 col2 col3
1 6 q
7 9 e
11 25 m