Google sheet function to extract values based on nested conditions. (Complex)
I am trying to solve for a problem. I have a name range and a condition range.
| Name | Yes/No |
|---|---|
| First | row |
| Second | row |
I have a master data sheet containing various values associated with different names. I aim to display these values in a new column only if a corresponding 'Yes/No' indicator for each name is set to 'Yes'. For instance, if the 'Yes/No' indicator for the name 'X' is set to 'Yes' for all associated values, I intend to exhibit these values from the master data in a new column (Column 3).
However, in my current approach, which involves utilizing the IF and QUERY functions, I encounter an issue where the execution of the first condition seems to prevent the evaluation of subsequent conditions. How can I ensure that all conditions are properly assessed?
Can you help me find a solution to this issue.
Any help would be appreciated.
This is the link to the sheet and my failed attempts at it.
https://docs.google.com/spreadsheets/d/1iB8_4-yTzM1HgdS8skE1Ce0nunoRU6F0rUq4WVzkO2E/edit#gid=0
Here's one approach you may test out:
=reduce({D2:E2,"Data Correct"},unique(tocol(D3:D13,1)),lambda(a,c,ifna(vstack(a,hstack(filter(D3:E13,D3:D13=c),if(countifs(D3:D13,c,E3:E13,"<>y")=0,filter('Master Data'!A:A,'Master Data'!B:B=c),))))))
- How to determine whether a function exists in a POSIX shell?
- Simplest/cleanest way to implement a singleton in JavaScript
- What is the difference between a "function" and a "procedure"?
- Is there a limit to the number of arguments passed to a fortran function?
- 2 Functions in 1 main program(Visual Studio 2013)
- When I modify a parameter inside a function, why does the variable passed as the argument not change?
- What is a non-local return?
- Have a function take some data and send it back
- Using a class to open same popup using document.querySelector
- Is `std::function` deprecated by `std::copyable_function` in C++26?
- Is there a JavaScript function that reduces a fraction
- How apply a function to every element of a matrix?
- Dynamic function name in JavaScript
- Why are class member functions inlined?
- How to create unique slugs from unique integers?
- How to get slugs and names of all order statuses in WooCommerce?
- Outer function returning multi-line values with the help of refcursors
- PHP Call to undefined function
- Computing the cross product of two vectors in Fortran 90
- I keep getting AttributeError: 'Toplevel' object has no attribute 'addtolist' when trying to call functions inside my toplevel class
- Simplify a Powershell one-line function that works with pipelines as well as conventional parameters
- javascript jquery function is this somehow wrong?
- Compare two arrays of objects, and remove if object value is equal
- error compiling in c user input
- How can I deploy cache when the order of arguments doesn't matter?
- C - function inside struct
- Automatically assign products to categories based on their product tags in Woocommerce
- R commands behave incorrectly when converted to a function: failed evaluation of variable in for loop
- Why Fatal error: Unexpectedly found NIL while unwrapping an Optional value
- Is c function prototype mismatch merely a warning