compare/find a duplicate telephone number within a row

[Grav11]

I am seeking assistance on the correct formula or function statement to use when attempting to compare/find a duplicate telephone number within a row.

Example - Column K2 is the phone number I want to compare/find a duplicate within cells L2, M2, N2,O2 & P2. Upon finding a duplicate within any of these cells I would like to receive a value of "DUP" or "NO DUP".

Cell Data Example: K2: 313-555-1212; L2: 313-555-0000; M2: 313-555-1212; N2: 313-555-1000; O2: 313-555-0000; P2: 313-555-1212. I would like to receive a "DUP" value since K2 equals one or more of cells L2-P2.

Your assistance is greatly appreciated!!!!

[NBVC]

tRY

=IF(ISNUMBER(MATCH(K2,L2:P2,0)),"DUP","NO DUP")

[Grav11]

YES!!! Thank you so much!!! I really appreciate it!!!