About 1,000,375 results (2,221 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.
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.
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 ...
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 ... What is the best way to return multiple values from a single column lookup? ... I want it to return all of the values that match within a week of ...
Lookup value across multiple sheets and return sheet name ...
https://support.google.com/docs/thread/293291880/lookup-value-across-multiple-sheets-and-return-sheet-name?hl=en Aug 28, 2024 ... ... (match(J2;tocol(indirect(v&"!A1:I");3);0));v;))));ifna(filter(a;a<>"");"No Match")). See if this helps. . Original Poster 2 Rings marked this ...
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.
=VLOOKUP Across Multiple Tabs, Return All Matches to Single Cell ...
https://support.google.com/docs/thread/89321601/vlookup-across-multiple-tabs-return-all-matches-to-single-cell?hl=en Dec 18, 2020 ... I want to do is to run a =vlookup that searches multiple tabs for a value on the current sheet, and returns all of the found into a single cell.
Trying to filter out rows based on if values match a different row for a ...
https://support.google.com/docs/thread/170594095/trying-to-filter-out-rows-based-on-if-values-match-a-different-row-for-a-lookup-function?hl=en Jul 10, 2022 ... Is there also a way to make lookup functions spit out multiple values? So if two cats are both the best at a job with a level of 6, it'll spit ...
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 ... With all the "|"s added, the formula should be looking for exact matches. I also added an IF function to conduct the lookup search only if ...
Two dimensional lookup - Google Docs Editors Community
https://support.google.com/docs/thread/26133356/two-dimensional-lookup?hl=en Jan 19, 2020 ... Currently in Excel I am using .a two dimensional lookup using Index and Match, but this is not the same in google sheets.
Retrieve value from last row based on multiple criteria - Google ...
https://support.google.com/docs/thread/8972210/retrieve-value-from-last-row-based-on-multiple-criteria?hl=en Jun 29, 2019 ... G matching the value in column A and the value in I3:J3. ... The if(A4:A="" is used stop it from trying to lookup values for rows with blank in ...
Average matched values from multiple sheets - Google Docs Editors ...
https://support.google.com/docs/thread/266076111/average-matched-values-from-multiple-sheets?hl=en Mar 27, 2024 ... ... matching average from the other sheets: = ... Wrap it with query to get averages grouped by names, then lookup the array of names to find the ...
MATCH function - Google Docs Editors Help
https://support.google.com/docs/answer/3093378?hl=en MATCH function · VLOOKUP : Vertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found.
Complex VLookup using multiple criteria and between two dates ...
https://support.google.com/docs/thread/126929914/complex-vlookup-using-multiple-criteria-and-between-two-dates?hl=en Sep 20, 2021 ... So, instead, I'm creating a lookup reference tab. For workload purposes, I need an array formula to automatically assign the row to a specific ...
VLOOKUP - Google Docs Editors Help
https://support.google.com/docs/answer/3093318?hl=en There's only one return value from each VLOOKUP function. If there are multiple search key values that match, the value in the return value column whose ...
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 ... This lookup formula uses the results of the formulas given above. Cheers --Hyde. Last edited Apr 25, 2022.
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 ... The method uses a lookup table of code and values that I placed in columns O and P. You could hide those columns or move the table to a ...
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've tried a bunch of things with Index Match and LookUp without success so thought I'd ask the community for help! Here is what I am trying to ...
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.
How to insert values from one column if there's a match in another ...
https://support.google.com/docs/thread/252642930/how-to-insert-values-from-one-column-if-there-s-a-match-in-another?hl=en Jan 9, 2024 ... I'm working in a sheet with multiple tabs. Each record in one of the tabs has a column that contains a percentage.