About 1,290,870 results (3,585 milliseconds)
Quickest way to search multiple rows/columns at once for a single ...
https://support.google.com/docs/thread/208630346/quickest-way-to-search-multiple-rows-columns-at-once-for-a-single-true-false-match?hl=en Mar 30, 2023 ... The quickest way to search multiple rows/columns at once for a single true/false match is to use the FILTER function.
Find value in multiple columns and output matching value in column ...
https://support.google.com/docs/thread/280223766/find-value-in-multiple-columns-and-output-matching-value-in-column-a-in-same-row?hl=en Jun 16, 2024 ... I'd like a formula that looks up a value (S Alabama) in the array (A97:E100), references this sheet, and outputs the value in the same row that is in column B ...
Query function - find multiple names from one column in another ...
https://support.google.com/docs/thread/101461031/query-function-find-multiple-names-from-one-column-in-another?hl=en Mar 9, 2021 ... I got this to work with match function, but when trying to match the scores, it totally crashed on me, plus I didn't get the "limit to 4" ...
How do I search across multiple columns for a partial string of text ...
https://support.google.com/docs/thread/121705592/how-do-i-search-across-multiple-columns-for-a-partial-string-of-text?hl=en Aug 17, 2021 ... Create a formula that will search across multiple columns and look for a partial string of text and indicate either yes or no that that text is there.
Using Vlookup / array formula with two columns of reference data ...
https://support.google.com/docs/thread/163110587/using-vlookup-array-formula-with-two-columns-of-reference-data?hl=en May 11, 2022 ... Both on the [search key] parameter as well as the FIRST column of the [range/array] parameter. The key is that in order to & together two full ...
How to QUERY/INDEX+MATCH multiple rows of text from a merged ...
https://support.google.com/docs/thread/11089976/how-to-query-index-match-multiple-rows-of-text-from-a-merged-cell?hl=en Aug 1, 2019 ... Hi, Dylan,. It is not recommended using merged cells or merged columns or merged rows in a data table for exactly the reason you are having an ...
Identify duplicates between two columns in Google Sheets - Google ...
https://support.google.com/docs/thread/152011014/identify-duplicates-between-two-columns-in-google-sheets?hl=en Feb 23, 2022 ... I am looking to have column A(entire column) cells highlight if there is a match in Column B(Entire column) I thought it would be simple but the formula I ...
Query Multiple Sheets in Same Spreadsheet but Only Specific ...
https://support.google.com/docs/thread/144011158/query-multiple-sheets-in-same-spreadsheet-but-only-specific-columns?hl=en Jan 4, 2022 ... Is there a way to search columns by Header names? I can easily edit the Column Names to match the names we choose. Just not sure if that's ...
How to merge multiple sheets with a query matching multiple dates ...
https://support.google.com/docs/thread/66797836/how-to-merge-multiple-sheets-with-a-query-matching-multiple-dates?hl=en Aug 24, 2020 ... sheet "money" contains 3 columns, date, inc euro, out euro; note 1: a date in the date column is unique (because pivot table); note 2: as you ...
FIND ALL OCCURANCES OF MULTIPLE KEYS IN GOOG;LE ...
https://support.google.com/docs/thread/55120655/find-all-occurances-of-multiple-keys-in-goog-le-sheet?hl=en Jun 23, 2020 ... I am trying to find ALL matches in Columns C that match items in Column B. If I use vlookup it only finds first match - I need all matches.
What is the best way to return multiple values from a single column ...
https://support.google.com/docs/thread/193895683/what-is-the-best-way-to-return-multiple-values-from-a-single-column-lookup?hl=en Dec 21, 2022 ... I want it to return all of the values that match within a week of the search key. Here is a screenshot: Ignore that there are SEVERAL columns ...
Vlookup in multiple columns - Google Docs Editors Community
https://support.google.com/docs/thread/198533016/vlookup-in-multiple-columns?hl=en Jan 23, 2023 ... 2) VLOOKUP and MATCH will search in the first column of the reference range only. in the sheet ice, I use this formula =MATCH(A2,FLATTEN(Table!
How to return multiple columns ( array ) on H/LOOKUP? - Google ...
https://support.google.com/docs/thread/128297984/how-to-return-multiple-columns-array-on-h-lookup?hl=en Sep 28, 2021 ... I put it in your sample sheet in cell N4. Hope this helps! Matt. =OFFSET(A4:B6;0;MATCH(A1;A3: ...
Query multiple tabs with same header name - Google Docs Editors ...
https://support.google.com/docs/thread/180051907/query-multiple-tabs-with-same-header-name?hl=en Sep 20, 2022 ... Because you are trying to combine two or more tables of which the column names may or may not match. So after merging two tables (tabs), the ...
How do I match up values in two columns and sum up the matches ...
https://support.google.com/docs/thread/34775548/how-do-i-match-up-values-in-two-columns-and-sum-up-the-matches?hl=en Mar 21, 2020 ... I've looked at SUMIF and VLOOKUP but just haven't landed on the right solution or just using the wrong terminology in my searches for an answer.
Index/Match not working in some cells - Google Docs Editors ...
https://support.google.com/docs/thread/266196298/index-match-not-working-in-some-cells?hl=en Mar 28, 2024 ... ... two sheets). Column M is a QUERY function looking for skus in A that match criteria in the hidden columns. Again, it works for almost all of ...
Lookup Matching Value Across Multiple Worksheets And Return ...
https://support.google.com/docs/thread/43383714/lookup-matching-value-across-multiple-worksheets-and-return-sheet-name?hl=en Apr 29, 2020 ... I need a formula to tell me that the email in the form (Google Form worksheet, column F) is also found in one of the other worksheets.
Using Index and Match to pull data to a new tab - Google Docs ...
https://support.google.com/docs/thread/8394435/using-index-and-match-to-pull-data-to-a-new-tab?hl=en Jun 20, 2019 ... I have a spreadsheet of appointments that all of my staff have booked with multiple columns. One column is labelled with the staff members name.
Array formula to return multiple column values using VLookup ...
https://support.google.com/docs/thread/250257105/array-formula-to-return-multiple-column-values-using-vlookup?hl=en Dec 25, 2023 ... That will only look for one match — the match for the key in A3. To find matches for all keys in A3:A, try something like this: = ...
how do I resize multiple colums in sheets? - Google Docs Editors ...
https://support.google.com/docs/thread/3874139/how-do-i-resize-multiple-colums-in-sheets?hl=en Apr 9, 2019 ... I am sure this is simple, just cannot find out how, and right clicking offers no joy, just row height, no column width options. Thank-you.