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.