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 access Javascript variable values outside of the function
- Running Azure functions locally gives "No runtime" error after .NET7 upgrade
- Wordpress rename uploaded images based on the post_title
- How do I make a variable accessable from the TimerTask() run function in Kotlin (Android)?
- dplyr -- different results using custom function
- Why am I unable to copy and execute a function in C?
- How to get the return value from a thread?
- How to auto-register test cases in a test system?
- Why does a function declared inside a conditionally-executed block appear to exist before the block is entered?
- Why does naming a function expression not make the name accessible within the scope, but still possible to delete?
- Why my function in Javascript is not working?
- How can I get Python to start executing from a specific line of code when the code is first run?
- Cannot understand why pd.Series.map fails with a lambda function
- performance difference between User Defined Function and Stored Procedures
- firebase deploy --only functions overrides existing functions
- How to Prevent Wordpress from Stripping HTML Tags in Excerpt
- My table has a date column. I need a function that flags rows as True within the same group if there are a total of more than n rows within m months
- Pass function argument as data-toggle attribute?
- How get JSON data from inside a function and display it on textfield in swift?
- How do I get the function name inside a function in PHP?
- Overhead in unused code
- How can I call several user_names in the Twitter API?
- how to make a function available at start up in R
- Creating Clock in React
- `static` keyword inside function?
- In Python, what does '<function at ...>' mean?
- How to programmatically determine if the default parameter value was used?
- Unable to create a local function because "can't capture dynamic environment in a fn item"
- Use a bash function inside an 'at' job
- How to use eval() in a function from library with functions which are defined outside of this library?