hi Max,
You can read the link back to the original discussion to get an idea on what
I was originally trying to accomplish. it's quite detailed, and provided Biff
with enough to make up the two formulas.
This modification is simply an expansion on that original idea.
I.e., I had two worksheets- a source sheet, and a criteria sheet.
Now I have three source sheets, and still a single criteria sheet.

I'm looking at the source sheet's list of names, and comparing that to the
criteria sheet to see if all the names are on both. If I'm missing names, I
get a numeric response for the first formula. The second formula reads the
numeric value of the first, and gives me the names that are missing.

Let me know if you require further clarification.

Thanks for your reply.

"Max" wrote:

Think there's probably a simpler way to get whatever you want going with a
helper col or two. Try re-explaining your basic sheet set-up & objectives,
show some sample data and expected results.
--
Max
Singapore
---