Hello,

I am currently using the syntax below to achieve a result of "TRUE" or FALSE
on the designation spreadsheet.
ActiveCell.Formula =
"=ISNUMBER(MATCH(D2,[Cindy_PERSONAL.XLS]Sheet1!$F$2:$F$40,0))"

D E F G
Cindy Ren Fred Jon
27109 27598 27028 11208
27206 27600 27076 11210
27210 27649 27386 12210

What I would like to do is be able to return the name of the user (First
cell in each column) if any of the values in their respective columns match
the designation spreadsheet.

Thank you,