| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to set up: If cell X =1, value is A, if cell X =2, value is B
Cell A1 could have one of 12 values. Each of those values is associated with
one of 12 values listed in Column D. How do I get Cell A1 to know which value to pick out of Column D? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to set up: If cell X =1, value is A, if cell X =2, value is B
See this:
http://contextures.com/xlFunctions02.html -- Biff Microsoft Excel MVP "snowsaw" wrote in message ... Cell A1 could have one of 12 values. Each of those values is associated with one of 12 values listed in Column D. How do I get Cell A1 to know which value to pick out of Column D? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to set up: If cell X =1, value is A, if cell X =2, value is B
How do the values in column D correspond to those entered in column A? Can
you give an example? "snowsaw" wrote: Cell A1 could have one of 12 values. Each of those values is associated with one of 12 values listed in Column D. How do I get Cell A1 to know which value to pick out of Column D? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
| Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
| Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
| How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell | Excel Worksheet Functions | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
Linear Mode
