I am Trying to pull data from part of a sheet to another part depending on if dirt level 22 value is filled in. Please see attached Picture, basically, the bottom section pulls data from rows above depending on if dirt level 19, 20, 21 or 22 is displayed. I have only used 22 in the image.
Google-sheets – Pull data when cell value is selected
formulasgoogle sheetsgoogle-sheets-arrayformulagoogle-sheets-queryvlookup
Related Topic
- Google-sheets – Update the reference in Indirect() when new columns are added
- Google-sheets – Using Query and Importrange to pull Google Form data from one worksheet to another
- Google-sheets – Filtering a QUERY using MATCH – how to pass column value into function? Or is there a better way
- Google-sheets – Query Function Not Putting Consolidated Data in the Right Place
- Google-sheets – Trying to make a column of “select count” in reference to another column
- Google-sheets – Stacking IF Statements
- Google Sheets – How to Use Query to Find Row of Same Name and Copy Value
- Google Sheets – How to Use Query to Find Row of Same Name but Last Entry and Copy Value
Best Answer
paste in AH27 cell:
paste in AT27 cell: