Enter this formula in D1:

=INDEX(A$1:A$10,MATCH(C1,B$1:B$10,-1))

and copy down for as many values as you have in column C.

I would suggest that you change your entry in B1 to 110 (or something
similar) rather than the text "over65".

Hope this helps.

Pete

milos wrote:
Hi, I have a table with norms:
a b

1 10 over65
2 9 65
3 8 58
4 7 50
5 6 43
6 5 36
7 4 29
8 3 22
92 14
101 7

And I have a table of results
c d
1 35 x1
2 15 x2
3 13 x3
4 23 x4
5 32 x5
6 35 x6
etc.
x1-x6 should be filled automatically with the proper category - if first
result is 35, then the category (x1) should be 5 (it's more then 29, but less
then 36). x2 should be 3, x3 - 2 etc. how can i write conditions for this.
thanx