if-statementgoogle-sheetsmatchgoogle-sheets-formulaflatten
Search for a value in multiple columns and return value from Column A
Sheet Example:
| A | B | C | D | E | F |
|---|---|---|---|---|---|
| Jonas | 1 | 6 | 11 | 16 | 21 |
| Joaquin | 2 | 7 | 12 | 17 | 22 |
| William | 3 | 8 | 13 | 18 | 23 |
| Mark | 4 | 9 | 14 | 19 | 24 |
| Stuart | 5 | 10 | 15 | 20 | 25 |
Search value example:
19
Expected Return:
Mark
Formula indicated:
https://stackoverflow.com/a/55119579/11462274
=QUERY(Clients!A1:F, "select A where B="&B1&"
or C="&B1&"
or D="&B1&"
or E="&B1&"
or F="&B1&"", 1)
But the result is:
Jonas
Stuart
Why is Jonas returning when there is no value 19 in row 1?
An additional info:
If I have Columns from B to CC with values, is this still the indicated method? I ask because of the immense amount of lines I would have to write one by one for each of these columns.
Solution
try:
=INDEX(TEXTJOIN(", ", 1, IF(B1:F5=I1, A1:A5, )))
- Conversion operator and bool operator for if init expression
- Mysql How to only select from a column if the column exists
- Unable to use IF statement in plpgsql
- Trouble Excluding Named Worksheets from a Loop
- Adding only some data labels and a total value at the top of my stacked bar chart
- Good C-coding style for multiple lines if conditions
- If statement to check if an array is not in another array
- Determining if a string contains a word
- How can I make a def function with my "if" statements?
- How to assign a variable in an IF condition, and then return it?
- Using or in if statement (Python)
- C# Creating a Square
- Return TRUE/FALSE column for checking if a set of columns contains a value/string
- Does Go have "if x in" construct similar to Python?
- Does if (myBool == true) differ computational wise to if(myBool)?
- Write a Basic Car rental program on java / problems
- Writing a "Chessboard" function in Python that prints out requested length of binary
- Will my program execute "else" even if it executed my "if"?
- Why Java does not see that Integers are equal?
- How to have the Xcode 3.1 compiler warn of assignment operator in an if statement?
- Nested if Statement good or bad?
- How to write if statement in .tmux.conf to set different options for different tmux versions?
- is not null Vs != null (Unity C#)
- VBA "does not equal" code not stepping through IF statement as expected
- Avoiding nested if else statement ladder in Python
- I want to take output from a function to use in a IF statement in another function
- What actually happens when we put conditions without [] (brackets) in if else block in a bash script?
- C++ The if statement is still true even when only one condition is met
- Fortran if statement errors
- How can I change certain values in a column based on multiple conditions, leaving others as they are if the conditions aren't met?