Formula Search Loop - Search table for match of record in a different table

Hello!!! I am seeking assistance with my formula. I am trying to do something like an Index/ Match kind of deal with my table. I have a table of people onboarded. I have another table that lists lead...