Google-sheets – Searching Multiple Columns From Single Source Sheet in Google Sheets

google sheetsgoogle-sheets-filter

I have a Sheet where I have all of my data entered. I have been able to filter the information to other sheets no issues when only searching in one column. I am having issues when trying to search 2 columns at the same time.

On the Source Page, I have my date listed under the following headers: Player Name (A), OVR (B), Series (C), Primary (D), Secondary (E), Bats (F), Throws (G), How To Acquire (H), Team of Card (I) & Teams Played For (J).

For most sheets, I have been able to use the following formulae:

=SORT(FILTER(Cards!1:1000,SEARCH("Giants",Cards!J1:J1000)),2,false,1,true)

My issue comes from when I try to search both Primary and Secondary at the same time. I was able to use a query that searched both columns but am unable to do using SEARCH.

Best Answer

It is always challenging (and sometimes impossible) to provide meaningful answers based on snippets of information. However, given what you've shared here, try setting up your two-column search the same way as your one-column search, but structure the SEARCH portions this way:

SEARCH(ColD parameters) + SEARCH(ColE parameters)

The + serves as an OR.

Related Solutions

Google-sheets – Individual time stamps for individual sheets in a Google Spreadsheet containing multiple sheets

Don't use several onEdit-functions. Places place both IF-statements in the same tag.

Also, you shouldn't have semicolons after the IF-statements brackets.

function onEdit() {
 var s = SpreadsheetApp.getActiveSheet();
 if( s.getName() == "General Meeting Attendance Roster" ) { //checks that we're on the correct sheet
       s.getRange('S6').setValue("Roster last updated: " + (new Date()));
  }

 if( s.getName() == "Master Chapter Roster" ) { //checks that we're on the correct sheet
       s.getRange('K1').setValue("Chapter Roster last updated: " + (new Date()));
  }
}

Google-sheets – “-Ls 1000” in Google Sheets

Your entry is being interpreted as a Latvian currency value.

Would not happen if you switched to new Google Sheets. Meanwhile your solution is about as good as it gets.

-1,000 Lats puts you out of pocket by around USD1,800 ;-)

Best Answer

Related Solutions

Google-sheets – Individual time stamps for individual sheets in a Google Spreadsheet containing multiple sheets

Google-sheets – “-Ls 1000” in Google Sheets

Related Topic