About 1,081,824 results (4,485 milliseconds)
How to concatenate multiple values from multiple matches - Google ...
https://support.google.com/docs/thread/149137705/how-to-concatenate-multiple-values-from-multiple-matches?hl=en Feb 3, 2022 ... I have a spreadsheet filed with area codes, area names and zip codes. Every row is a different zip code (sometimes there are duplicates), but it can be in the ...
How to loop the index and match which return multiple results ...
https://support.google.com/docs/thread/160531026/how-to-loop-the-index-and-match-which-return-multiple-results?hl=en Apr 20, 2022 ... I want to sum all amount of the invoice from the suppliers that is electricity that the user have indicated under key. I have tried index and match but it only ...
Want to sum multiple values based on multiple drop down chips ...
https://support.google.com/docs/thread/318111059/want-to-sum-multiple-values-based-on-multiple-drop-down-chips?hl=en Jan 11, 2025 ... I've tried a combination of find, match, index, sumif, and other formulas but I'm getting stuck. I can use =Index(<table modifier value>, match ...
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 ... I wish to search a range that spans multiple rows and columns to find a match for a name, then if it finds said name, return the value TRUE.
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 ... I've been trying multiple methods of using VLOOKUP, INDEX+MATCH, and QUERY to output 2-3 rows of information based on a drop-down merged cell.
Lookup with multiple values to return in a list - Google Docs Editors ...
https://support.google.com/docs/thread/150642928/lookup-with-multiple-values-to-return-in-a-list?hl=en Feb 13, 2022 ... Also, the second link says that you are using an Excel formatted file. Are you intending to use a Google Sheet with a Microsoft Excel file?
Match a cell with one value to a cell with multiple lines of value ...
https://support.google.com/docs/thread/145153071/match-a-cell-with-one-value-to-a-cell-with-multiple-lines-of-value?hl=en Jan 11, 2022 ... I am trying to match a list of "Drawing numbers" against people who are working on them based on the drawing numbers that person is working on.
Index Match Multiple Criteria W/ Partial String Match & Value Match ...
https://support.google.com/docs/thread/145364829/index-match-multiple-criteria-w-partial-string-match-value-match?hl=en Jan 12, 2022 ... I'm having issues when using Index Match for multiple criteria. · Key points: · - I would also like to to match an exact value -- eg: CELL=COLUMN.
Formula to return multiple results - Google Docs Editors Community
https://support.google.com/docs/thread/228373179/formula-to-return-multiple-results?hl=en Aug 1, 2023 ... Edit: I have seen Index & Match that may be the solution to this issue, but I would like it to return the 5 most resent results, not the first ...
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 ... N2:V10,2), but that would only give me the value in the single cell that most closely matches the date in B3 while I need all of the dates ...
Using regexmatch with multiple conditions: match everything except ...
https://support.google.com/docs/thread/82447350/using-regexmatch-with-multiple-conditions-match-everything-except-several-characters?hl=en Nov 11, 2020 ... I'm using IFS and REGEXMATCH to assign values to each cell. The desired outcome is to return 'Info' if a cell contains 'how' 'where' 'what' 'who' but at the ...
Summing up values that meet multiple criteria (in a way that is ...
https://support.google.com/docs/thread/180317562/summing-up-values-that-meet-multiple-criteria-in-a-way-that-is-compatible-with-excel?hl=en Sep 21, 2022 ... However, this does not work when downloaded as an Excel file. I've been trying stuff with countif/index/match, but it seems like it's going to ...
Having multiple values in one cell - Google Docs Editors Community
https://support.google.com/docs/thread/265682904/having-multiple-values-in-one-cell?hl=en Mar 24, 2024 ... ... rows, and the corresponding "checked" rows (labelled "Done"). I recreate the matching date values, but with a bit of extra work, it could ...
REGEXEXTRACT For Multiple Number Sets - Google Docs Editors ...
https://support.google.com/docs/thread/246349211/regexextract-for-multiple-number-sets?hl=en Nov 30, 2023 ... To skip the first number, and extract the two following numbers, you could match the three numbers, but use parenthesis only on the ones you ...
Using Filter/Regexmatch for multiple values - Google Docs Editors ...
https://support.google.com/docs/thread/161436354/using-filter-regexmatch-for-multiple-values?hl=en Apr 27, 2022 ... We use the following formula to add all the information for the people who have booked a specific day into that tab =FILTER('All ...
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.
Can you enter multiple data in one cell and parse them separately ...
https://support.google.com/docs/thread/7671180/can-you-enter-multiple-data-in-one-cell-and-parse-them-separately-when-referencing-the-cell?hl=en Jun 8, 2019 ... If I'm reading the description of Vlookup correctly, setting the is_sorted element would allow partial matches to throw off the results. Is that ...
One filter, multiple email addresses
https://groups.google.com/g/gmail-power-users/c/eSxF3VYB1Fk ... values in the subject or message lines for about six more stated numbers: ... @234.com", and not just their domain "234.com", unless you want your filter to match ...
Need help with INDEX MATCH between two dates with multiple results
https://support.google.com/docs/thread/179047442/need-help-with-index-match-between-two-dates-with-multiple-results?hl=en Sep 12, 2022 ... I'm trying to create a list of all the clients I have worked with between two specific dates. I've tried a bunch of things with Index Match and LookUp without ...
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 ... I know how to achieve this with e.g. php and mysql with a simple loop where I compare the respective value of each record against the matching ...