Google Sheet - copy range if match
Please see this example sheet: Example Sheet
I have some known data in B2:W18 I would have this data copied to B22:W24 if the value in A22:A24 matches the value in A2:A18
The data that should populate automatically are colored in yellow
What could I do?
Solution
You may try with xlookup:
=xlookup(A24;A$2:A$18;B$2:W$18;)
- Automatically adding a row to a sheet with data from another sheet once every day
- Adding borders based on grouped rows and conditional formatting in Google Sheets
- Passing variables to time based triggers
- Google Apps script to conditional format cell border
- Google Sheet - copy range if match
- Multiple dropdown questions on a google-form tied to spreadsheet
- Google Apps Script sort stopped working "Exception: This operation is not supported on a table header row."
- count number of cells with precise number of repeated characters
- How to count distinct column values in Google Sheets?
- Pivot table (calculated field)
- How do I get Google Script to read the display value of a sheet's cell? It keeps returning some random date instead
- Google Sheets - make a list of the names in column A where column E is greater than zero
- Allocating Specific Leaves and getting Calculation
- Randomize cells in Google Sheets
- Google sheet insertImage function stopped working for Google Apps Script: verify image error
- Automating Date Headers for printable monthly attendance sheets
- Is it possible to browse a spreadsheet when an importrange has been authorized?
- Disable Spreadsheet copy - Google Sheets
- Gsheet AppScript ShowModalDialogue no longer displaying HTML hyperlink
- IMPORT XML function - Stock Price - Google Sheets
- Combining array_constrain and arrayformula and getting results in multiple columns
- Combining scripts
- Google script to dynamically addressing a cell in google sheet
- Authorization is revoked every week. How to maintain persistent authorization?
- Best Practices for Multiple OnEdit Functions
- Sheets: My function uses commas to separate the INDEX MATCH results, but I don't want a comma for the blanks while still having them on matches
- Google Sheets Sumifs two arrays (Month and current year)
- Can't get basic vlookup working for some reason on google sheets
- Processing date formats in data from Forms
- ARRAYFORMULA with IMPORTRANGE