About 1,179,607 results (1,383 milliseconds)
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 ... Are you intending to use a Google Sheet with a Microsoft Excel file? ... VLOOKUP is designed to only find the first instance of matching data.
Formula to return matching value from list for a string of text - Google ...
https://support.google.com/docs/thread/135881852/formula-to-return-matching-value-from-list-for-a-string-of-text?hl=en Nov 17, 2021 ... I need to match a string a texts (column A) to a list of values (column E) to return for that value (column B). I have found many solutions for single words, ...
How to return a list that matches part of the contents of a cell ...
https://support.google.com/docs/thread/112509681/how-to-return-a-list-that-matches-part-of-the-contents-of-a-cell?hl=en Jun 5, 2021 ... Looking to return a list of text if part of a cell contains a specified value in another tab. So in this example, I'm pulling data from the ' ...
Compare two lists and return only those values that are missing from ...
https://support.google.com/docs/thread/7345105/compare-two-lists-and-return-only-those-values-that-are-missing-from-one-list?hl=en Jun 3, 2019 ... I have two queries pulling in data to form two lists. I need to compare the names in List 2 with the names in List 1 and create a 3rd list for those that are ...
MATCH function - Google Docs Editors Help
https://support.google.com/docs/answer/3093378?hl=en Returns the relative position of an item in a range that matches a specified value. Sample Usage MATCH("Sunday",A2:A9,0) MATCH(DATE(2012,1,1),A2:F2) Syntax ...
Matching 2 columns and returning value from 3rd column - Google ...
https://support.google.com/docs/thread/3989016/matching-2-columns-and-returning-value-from-3rd-column?hl=en Apr 11, 2019 ... ... list as well), but these are in a completely different order than the big list. Example below: I need help with a formula that can look at ...
Is it possible for a formula to search from a dynamic list against a ...
https://support.google.com/docs/thread/109240086/is-it-possible-for-a-formula-to-search-from-a-dynamic-list-against-a-static-list?hl=en May 9, 2021 ... I'm trying to get the sheet to compare a dynamic list against a static list and return a value if the match is made.
If cell value matches list of values, add value of a second cell ...
https://support.google.com/docs/thread/116926865/if-cell-value-matches-list-of-values-add-value-of-a-second-cell-unorthodox-layout?hl=en Jul 13, 2021 ... So for the rows with class ID only, it tries to find the values fro B3 to L23 within the classlists column A. If there is a match, it returns a ...
Return a Value based on Substring Match of an Array - Google Docs ...
https://support.google.com/docs/thread/132454747/return-a-value-based-on-substring-match-of-an-array?hl=en Oct 25, 2021 ... I have a list of values that I am trying to normalize. I'd like to search these values and compare against a reference table I have and return a value based on ...
Google Sheets drop down: choose text from list, return number in cell
https://support.google.com/docs/thread/13293015/google-sheets-drop-down-choose-text-from-list-return-number-in-cell?hl=en Aug 31, 2019 ... So lookup the text value and return it's corresponding number. The false tells vlookup that the data (G2:H) is not sorted and an exact match ...
Filter function with a list of matching values - Google Docs Editors ...
https://support.google.com/docs/thread/153722283/filter-function-with-a-list-of-matching-values?hl=en Mar 6, 2022 ... Later i am going to use this new list of repeating values to fill them with a index/match function. I need that this formula would be universal ...
Need a function that flags non-matching cell values from VLOOKUP ...
https://support.google.com/docs/thread/112282330/need-a-function-that-flags-non-matching-cell-values-from-vlookup?hl=en Jun 3, 2021 ... I think a simple =IFERROR(MATCH(...),TRUE) would return TRUE both for the matches, and for the ERRORs. ... list of matches, in column O. Hope that ...
How to print a list of values where certain criteria are met in other ...
https://support.google.com/docs/thread/54112087/how-to-print-a-list-of-values-where-certain-criteria-are-met-in-other-columns?hl=en Jun 17, 2020 ... Any of the LOOKUPS are only good if you want to return a single result as they stop when they find the first match. Last edited Jun 18, 2020.
Using an Array Formula, Find matches in a cell from a list and return ...
https://support.google.com/docs/thread/162115590/using-an-array-formula-find-matches-in-a-cell-from-a-list-and-return-the-match-es?hl=en May 3, 2022 ... I need to have a specific cell checked for occurances of any of the words in the list and then return the matching words found.
Google Sheets function list - Google Docs Editors Help
https://support.google.com/docs/table/25273?hl=en Tests an expression against a list of cases and returns the corresponding value of the first matching case, with an optional default value if nothing else is ...
Match two columns of data and correlate matching data from a 3rd ...
https://support.google.com/docs/thread/285697031/match-two-columns-of-data-and-correlate-matching-data-from-a-3rd-column?hl=en Jul 16, 2024 ... I'm trying to find a formula to match/compare the 2 email columns and return the "ID" value to the "Matching ID" that is inline with the ...
MATCH function not finding value - Google Docs Editors Community
https://support.google.com/docs/thread/180024342/match-function-not-finding-value?hl=en Sep 19, 2022 ... I have a sheet with two lists of names: a list of names that have salary information, and a list of all names. ... "Did not find value ' ' in ...
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 ... So the email address will be checked on list of 1000 or so emails, and if it's found it will output the first sheet found. If it is not found " ...
Find & delete specific cell data from a range. Remove matching ...
https://support.google.com/docs/thread/3846279/find-delete-specific-cell-data-from-a-range-remove-matching-values-in-b-b-from-a-a?hl=en Apr 9, 2019 ... Remove matching values in B:B from A:A. I have a small list of cities I want to remove from a full list of all United States cities ...
Find closest match in list (rounding up OR down) and return ...
https://support.google.com/docs/thread/77186813/find-closest-match-in-list-rounding-up-or-down-and-return-adjacent-value-to-rounded-match?hl=en Oct 15, 2020 ... The formula needs to find the closest value in Column A to the search value using standard rounding rules, and then return the appropriate value from Column B.