If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 =4050 8 =3040 7 =2030 6 =1020 5 =510 4 =34 3 =23 2 =12 1 01 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? |
#2
|
|||
|
|||
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 =4050 8 =3040 7 =2030 6 =1020 5 =510 4 =34 3 =23 2 =12 1 01 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? |
#3
|
|||
|
|||
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 =4050 8 =3040 7 =2030 6 =1020 5 =510 4 =34 3 =23 2 =12 1 01 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? |
#4
|
|||
|
|||
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 =4050 8 =3040 7 =2030 6 =1020 5 =510 4 =34 3 =23 2 =12 1 01 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? |
Thread Tools | |
Display Modes | |
|
|