Lookup And? Need formula help

  • Thread starter Thread starter Sandy
  • Start date Start date
S

Sandy

If cells X4:AC4 = "M Mail List" then return the value "M
Mail List" to cell V4

As simple as it sounds, I can't get my brain around how to
write a formula for this.

Any help is appreciated.
Thanks.
sandy
 
One way to approach it:

If *all* cells in the range must contain the string, enter this in V4:

=IF(COUNTIF(X4:AC4,"m mail list")=6,"m mail list")

If *any* cell in the range contains the string, enter this in V4:

=IF(COUNTIF(X4:AC4,"m mail list")>0,"m mail list")

If the conditions are not met, "False" is returned by the formulas.

If cells X4:AC4 = "M Mail List" then return the value "M
Mail List" to cell V4

As simple as it sounds, I can't get my brain around how to
write a formula for this.

Any help is appreciated.
Thanks.
sandy
 
Back
Top