Help needed for this newbie ... I'm using Excel2007 btw.
This is so simple but I just don't know why I can't get it to work:

A B
10 =50
9 =40<50
8 =30<40
7 =20<30
6 =10<20
5 =5<10
4 =3<4
3 =2<3
2 =1<2
1 0<1
0 0

I just need to look up a value in Cell C1, compare to col B, look up its
corresponding value in col A, and put the value in D1.

I tried the nested IF work-around at http://www.cpearson.com/excel/nested.htm
but it's still not working correctly. Help?