Do me a favour. Close off this thread for the record by pressing the YES
button (like the one below) in the earlier response since you got the answer,
albeit you omitted mention of it in your feedback.

As for your new query below, well you've correctly re-posted it afresh in a
new thread ..
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik
---
"SiH23" wrote:
Is it possible in excel to run a search that checks if the details in 2 cells
of a row occur together again in the any row but different columns. for
instance:

D2 = JOE
E2 = BLOGGS

Check if JOE is present anywhere in column M with BLOGGS also present in
that same row in column N