About 1,955,109 results (4,021 milliseconds)
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 10, 2022 ... I'm struggling to figure out if I can use a Vlookup formula when I have two columns of data to refer to? ... matches running from bottom to top - ...
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 ... ... column E for every item. Example below: I have tried for a couple of hours with different Vlookup & match formulas, but I just can't get it to ...
How to compare two columns from two different sheets and return ...
https://support.google.com/docs/thread/6497440/how-to-compare-two-columns-from-two-different-sheets-and-return-the-third-column-if-they-match?hl=en May 20, 2019 ... =ArrayFormula(vlookup(A2:A&char(9)&B2:B,{Sheet2!A2:A&char(9) ... Excel file) with some sample but realistic. data and then taking one ...
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.
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 ... ... rows that matched. Column L is the column with the "row numbers", ie where a match was found. You can see row 2, Roy Kinsey | The Rapbrarian ...
LOOKUP - Google Docs Editors Help
https://support.google.com/docs/answer/3256570?hl=en If a different row or column is desired, use VLOOKUP or HLOOKUP instead. ... If the range contains an equal number of rows and columns or more rows than ...
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 ... Maybe, I should have a helper column for the type and place, then if they match it could look up a date and then the second date?
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 ... =arrayformula(iferror(vlookup(. C1:C,. 'Tab 2'!A1:B,. columns('Tab 2'!A1:B),. true. ))) This array formula will fill a whole column in one go.
Compare 2 sheets for similarities and differences even if on different ...
https://support.google.com/docs/thread/10262301/compare-2-sheets-for-similarities-and-differences-even-if-on-different-rows?hl=en Jul 20, 2019 ... There are formulas in A1, B1, and D1 that compare the two sheets in the respective columns. ... Then a lookup of sheet1 column C values in ...
2 cells input, 1 cell output, Struggling with VLOOKUP - Google Docs ...
https://support.google.com/docs/thread/137785514/2-cells-input-1-cell-output-struggling-with-vlookup?hl=en Nov 29, 2021 ... But how can you pull a result based on the columns being sorted and using the 1 (approximate match)?. James :).
MATCH function - Google Docs Editors Help
https://support.google.com/docs/answer/3093378?hl=en ... column the match is found in, use INDEX , HLOOKUP , or VLOOKUP . See Also ... matches a specified value based on different search_type . Make a copy.
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 ... Automatically filters out columns if one of the jobs for a Cat is selected, and then column Y will search which unassigned Cat is the best for the job.
Trying to find matching data in two columns on two sheets, then ...
https://support.google.com/docs/thread/240661419/trying-to-find-matching-data-in-two-columns-on-two-sheets-then-return-the-value-of-another-column?hl=en Oct 24, 2023 ... lookup, arrayformula(ifna(. vlookup(billHistoryKeys, hstack(dataKeys, data), { 2, 3, 4, 5, 6 }, false). )),. table, hstack(lookup, billHistory),.
How to concatenate a specific column ONLY in a query between two ...
https://support.google.com/docs/thread/184455563/how-to-concatenate-a-specific-column-only-in-a-query-between-two-sets-of-data?hl=en Oct 17, 2022 ... ... combine students who are both lists to avoid redundancies. This has ... lookup function to match the column in the other tab and then ...
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.
Update different columns based on text value of other cells. - Google ...
https://support.google.com/docs/thread/7826333/update-different-columns-based-on-text-value-of-other-cells?hl=en Jun 11, 2019 ... ... MATCH to skip the row if the appropriate cell contains "Alloted". I ... Then added formulas in H and I to lookup the email in the email ...
lookup on two different items and return item based by date - Google ...
https://support.google.com/docs/thread/139744760/lookup-on-two-different-items-and-return-item-based-by-date?hl=en Dec 10, 2021 ... Note that it is very specific to the structure of your sheet, since I have to force it to match where you have merged cells. Let me know if ...
Google Form Response sheet, vlookup and Concatenate formula ...
https://support.google.com/docs/thread/326058454/google-form-response-sheet-vlookup-and-concatenate-formula?hl=en Feb 19, 2025 ... On my lookup sheet it has their names in two columns, so I wrote a ... Allows forum volunteers to match their solutions to your outcome
How to use or in an arrayformula? - Google Docs Editors Community
https://support.google.com/docs/thread/185220142/how-to-use-or-in-an-arrayformula?hl=en Oct 22, 2022 ... I am not the expert in excel formulas, I am ... From my understanding, you want to search/match a value in a lookup table (in two columns).
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.