Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need help with Excel formula!!
On worksheet tab 1, I have a list of numbers (col a) ranging from one to twenty and a dollar value (col b) assigned to each. On the next worksheet tab I have a list of names in col a and when I put a number on the next column, I want col c to go to the first worksheet and give me the corresponding dollar value assigned to that number. I am trying to use the IF function, but with 20 different values, isn't there anything simpler? =IF(a1=1,sheet1!b1,IF(a1=2,sheet1!b2,IF(a1=3,sheet 1!b3........................... Isn't there a better way? If not, how does this end? -- Need formula!! ------------------------------------------------------------------------ Need formula!!'s Profile: http://www.excelforum.com/member.php...o&userid=26265 View this thread: http://www.excelforum.com/showthread...hreadid=395594 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does Excel show a formula in ONE cell ? | Excel Discussion (Misc queries) | |||
Excel CHALLENGE...3 questions(indirect,rank,array formula)... | Excel Worksheet Functions | |||
converting formula from lotus.123 to excel | Excel Worksheet Functions | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions |