Simple Lookup, Why Error?

[Jhon Mustofa]

hi all...

how to fix it :

Range
0-19 20-39 40-59 >=60
100
125 147
45 49 78
47 20 59 87
10 12 16 47
79 45 68


Range (Given) After Formula/Result
25 #N/A

thanks in advance..
john m

[tim201110]

=index($c$5:$f$10,match(c14,$c$5:$c$10,-1),match(c14,{0;20;40;60})+1)

[jeffreybrown]

Not sure I understand what you are trying to achieve.

With the range given as 25, what do you expect the result to be?

[Jhon Mustofa]

sorry, i confused..this my new file attachment..

[JohnTopley]

Try

=INDEX($C$5:$E$8,MATCH($B$12,$B$5:$B$8,1),MATCH($C$12,$C$4:$E$4,1))

Set headings as shown in attached.

[Jhon Mustofa]

hi John,,great!! Worked...thanks you...

[AlKey]

You can also use this
Enter formula in D12

Please Login or Register  to view this content.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.