Nested IF confusion!
 

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?

Nested IF confusion!
 

Maybe this

=LOOKUP(C1,B1:B20,A1:A20)

Sort on column B in ascending order.

HTH,
Paul

--

"JayPee" wrote in message
...
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?

Nested IF confusion!
 

You cannot use those text representation of greater than equal to less than
equal to etc if that is what you do?

You would be better served if you switch order both column and row wise

0 1
1 2
2 3
3 4
10 6
20 7
30 8
40 9
50 10


then use

=IF(C1=0,0,VLOOKUP(C1,A1:B11,2))

--


Regards,


Peo Sjoblom

"JayPee" wrote in message
...
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?

Nested IF confusion!
 

I see ... thank you!!!

"Peo Sjoblom" wrote:

You cannot use those text representation of greater than equal to less than
equal to etc if that is what you do?

You would be better served if you switch order both column and row wise

0 1
1 2
2 3
3 4
10 6
20 7
30 8
40 9
50 10


then use

=IF(C1=0,0,VLOOKUP(C1,A1:B11,2))

--


Regards,


Peo Sjoblom

"JayPee" wrote in message
...
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?