Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i use "if" in cell that ref another with text from a pulld.
I am trying to create a what if scenario. I have cell A8 that is linked to a
combo box, which is linked to N4:N15 where I am using text. I want a number to be placed in cell C8 based on what cell A8 is in the combo box. How do I manage this, or can I? John |
#2
|
|||
|
|||
Sounds like a job for VLOOKUP............
In cells O4:o15, put the numbers you wish to shoe\w up when each stxt value in N4:n15 is called up in A8 ................. Then, in C8, put this formula......... =VLOOKUP(A8,N4:O15,2,FALSE) Then, whatever value is selected in A8, the corresponding number will appear in C8....... Vaya con Dios, Chuck, CABGx3 "John" wrote in message ... I am trying to create a what if scenario. I have cell A8 that is linked to a combo box, which is linked to N4:N15 where I am using text. I want a number to be placed in cell C8 based on what cell A8 is in the combo box. How do I manage this, or can I? John |
#3
|
|||
|
|||
Each item in the drop down (combo box) has a differnt value to it.
"CLR" wrote: Sounds like a job for VLOOKUP............ In cells O4:o15, put the numbers you wish to shoe\w up when each stxt value in N4:n15 is called up in A8 ................. Then, in C8, put this formula......... =VLOOKUP(A8,N4:O15,2,FALSE) Then, whatever value is selected in A8, the corresponding number will appear in C8....... Vaya con Dios, Chuck, CABGx3 "John" wrote in message ... I am trying to create a what if scenario. I have cell A8 that is linked to a combo box, which is linked to N4:N15 where I am using text. I want a number to be placed in cell C8 based on what cell A8 is in the combo box. How do I manage this, or can I? John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create a variable column in cell reference | Excel Worksheet Functions | |||
create a cell that accumulates, numbers from another cell... | Excel Discussion (Misc queries) | |||
How can I get a cell locked if the condition is false? | Excel Worksheet Functions | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel |