First of all, your formula is an *array* formula, and therefore requires a
CSE entry.

However, it's not clear what you're looking to concatenate.

There's *no* difference if F4 is either 2 or 3 ... is that correct?

Does this *array* formula work for you:

=IF(AND(OR(F4={2,3}),J4:R4="G"),"K40-MP1.0-N01MS"&" "&"K50-MP1.0-N02MS","")

--
Array formulas are entered using CSE, <Ctrl <Shift <Enter, instead of the
regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually. Also, CSE *must* be used when
revising the formula.

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Justlearnin" wrote in message
...
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