| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Defining an array to search by
I am trying to type a simple if.then formula, but would like to evaluate an
array of cells for the 2nd condition of the and statement. How do you designate this in the formula? Here is what I currently have: =CONCATENATE(IF(AND(F4=2,J4:R4="G"),"K40-MP1.0-N01MS",IF(AND(F4=3,J4:R4="G"),"K40-MP1.0-N01MS","K50-MP1.0-N02MS"))) If you have a better way to accomplish this task, any ideas would be appreciated. Thank You in advance for the help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text Search in an Array | Excel Worksheet Functions | |||
| Text Search in an Array | Excel Discussion (Misc queries) | |||
| How do I search an array for values in a column greater than zero | Excel Worksheet Functions | |||
| Search array and return element No | Excel Worksheet Functions | |||
| Search a random array of cells and return a value of "X" | Excel Worksheet Functions | |||
Threaded Mode
