Help w/ search formula to find records that contains two values

[chapelno]

Airtable novice here, need help crafting a search formula that will find the record that contains both a First Name and Last Name.  So in the attached screenshot, I will provide "Harley" and "Comber" and need Airtable to flag record 3 as satisfying the search.  I can't search based on an exact match because sometimes the name as it exists in the table includes a middle initial, full middle name, jr., sr., etc. that the document I'm pulling the first name and last name off of to do the search does not include.  But I will always have the first name and last name available to search.  

This is going in a Zapier routine that will provide the first name and last name for the search and then return the correct record so I can use the corresponding Matter ID in future steps.  

So, basically I need a formula that instructs Airtable to find the record that includes both the [First Name] and [Last Name] variables.  Thanks for your help.

[TheTimeSavingCo · Accepted solution]

Not sure I understand you fully, but try this:

AND(
  FIND(
    {First Name},Name
  ),
  FIND(
    {Last Name},Name
  )
)

[chapelno]

That did it - thanks very much.  Was the last piece of the puzzle for us.