How can we Search a Google Sheet for results that match multiple data points?

[RoCrow]

I have a spreadsheet with Event ticket booking data, that includes Email (or the attendee), Venue & Date columns

I would like to search that sheet to see if there are any entries that have a matching COMINATION of Email, Venue & Date data.

e.g. I want to pull up any row/s that contain ALL of: "[email protected]", "This Great Venue" and "2022-02-18"

(how) is that possible with Pabbly?

N.B. I know I can look up a Single value (e.g. JUST matches of the Email only, or Venue only, or Date only, but not how I can apply logic to match them all.

 

[Pabblymember11]

Hey @RoCrow

You can try the following workaround for your concern. Though it will pass the data directly to the destined API. You cannot use any other operation after the theses step.

 

[RoCrow]

Thanks @Supreme I'll have a play around with that and see if I can get it to work. I know there is a formula/syntax in Google Sheets that can be used to do it, I'm just not sure what it is. I was hoping there might be a more user-friendly front-end way of doing it in Pabbly (where you guys run the formula/syntax in the background and we can just fill in fields with our search terms! )

 

[Fagun Shah]

Thanks @Supreme I'll have a play around with that and see if I can get it to work. I know there is a formula/syntax in Google Sheets that can be used to do it, I'm just not sure what it is. I was hoping there might be a more user-friendly front-end way of doing it in Pabbly (where you guys run the formula/syntax in the background and we can just fill in fields with our search terms! )

Check this once -