I need help with an arrayformula that can look or check for names in a list based from a separate list of names.
The important part is it has to be case-sensitive and should return a "Not Found" error if it cannot find an exact match from a separate list.
In the sheet above, the separate list is in column F and it needs to check column B. The expected output is in column C. For row 3, "sean massey" should return a "Not Found" error because it can't find an exact case-sensitive match from column F.
IMPORTANT: There is an additional condition to this as well. I need the arrayformula to only be in cell D2 only and it will process the names in column B from top to bottom where column A is not empty.
Here is an editable sheet link anyone can use:

update:
=INDEX(IF(B2:B="",,IF(REGEXMATCH(B2:B,
"^"&TEXTJOIN("$|^", 1, F2:F)&"$"), "Found", "Not Found")))

