Help

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

Topic Labels: Automations Formulas
Solved
Jump to Solution
1046 2
cancel
Showing results for 
Search instead for 
Did you mean: 
chapelno
4 - Data Explorer
4 - Data Explorer

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.

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Not sure I understand you fully, but try this:

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

Screenshot 2023-02-16 at 4.26.15 PM.png

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

Not sure I understand you fully, but try this:

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

Screenshot 2023-02-16 at 4.26.15 PM.png

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