Defining an array to search by
While I do not know why you have the concatinate, I assume you do
and that you want j4=G,kr=G etc for all of the cells through R4
=if(and(concatinate(J4:R4)="GGGGGGGGG", or(F2=2,F2=3),"K40-MP1.0-N01MS",
"K50-MP1.0-N02MS" )
or
=if(And(J4:R4=1,or(F2=2,F2=3),"K40-MP1.0-N01MS", "K50-MP1.0-N02MS" )
entered as an array formula Control-shift enter
"Justlearnin" wrote:
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
|