ADDING ADDITIONAL LOGIC TO EXISTING FORMULA

[meppwc]

The following formula resides in cell Z2.
I need to add additional logic that includes:
If the value in Y2 = "MSN", then say "MSN NOT FOUND"
Follow the logic in the formula below.
=IF(ISNUMBER(MATCH(X2,Y2,0)), "Yes", "No")

 

[6StringJazzer]

Using MATCH and ISNUMBER is overly complicated to compare two cells. MATCH is used to find a value in a range of cells.

I don't understand the logic of finding "MSN" but then saying "MSN NOT FOUND", but here is exactly what you are describing:

=IF(Y2="MSN","MSN NOT FOUND",IF(X2=Y2,"Yes","No"))

 

[meppwc]

Using MATCH and ISNUMBER is overly complicated to compare two cells. MATCH is used to find a value in a range of cells.

I don't understand the logic of finding "MSN" but then saying "MSN NOT FOUND", but here is exactly what you are describing:

=IF(Y2="MSN","MSN NOT FOUND",IF(X2=Y2,"Yes","No"))

WORKED.............thanks so much

 

[6StringJazzer]

You're welcome!