Lookup From Interval Values

[muhammad susanto]

hi all..

how to find matching value from intervals, like this layout :

Excel 2007
	D	E	F	G
5	point	model	model	model
6		1	2	3
7	0-19	10	9	77
8	20-39	12	14	86
9	40-59	15	56	45
10	>=60	25	23	21
11
12
13	lookup/expected result
14	point (given)	model (given)	result
15	7	2	?
Sheet1

any help is greatly appreciated...

m.susanto

 

[AhoyNC]

Maybe something like this?

Excel Workbook
	D	E	F	G
5	point	model	model	model
6		1	2	3
7	0-19	10	9	77
8	20-39	12	14	86
9	40-59	15	56	45
10	>=60	25	23	21
11
12
13	lookup/expected result
14	point (given)	model (given)	result
15	7	2	9
Sheet

 

[muhammad susanto]

thanks you very much!!. ...Worked..!

 

[bosco_yip]

Another one....

In F15,

=INDEX(E$7:G$10,MATCH(D15,{0,20,40,60}),E15)

Regards
Bosco