'HOW TO SEARCH FROM GOOGLESHEET
how are you? this time I want to ask formula in googlesheet how to find data with multiple criteria and the criteria is dropdown for example i insert the sample link
https://docs.google.com/spreadsheets/d/1k0a_3LhMnVCiQ0pcOcFBfC7K5O2UAUugaeO6P1vSw7M/edit?usp=sharing
Solution 1:[1]
use:
=QUERY('DATA BASE'!A:F; "where 1=1"&
IF(B2="";;" and B = '"&B2&"'")&
IF(C2="";;" and E = '"&C2&"'")&
IF(D2="";;" and D = '"&D2&"'")&
IF(E2="";;" and F = "&E2))
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | player0 |