Google Sheets Formula for Searching Based on Multiple Criteria

Objective

To create a Google Sheets formula that searches based on the values of two specified cells and returns data from a third cell.

Formula

The formula to achieve this can be constructed using the FILTER function in conjunction with logical conditions. The structure would be:

=FILTER(C:C, A:A = D1, B:B = E1)

Explanation

• FILTER(range, condition1, condition2): This function filters a range based on the provided conditions.
  • range: The range from which data will be returned (here, C:C indicates that data will be extracted from column C).
  • condition1: The first condition (here, A:A = D1, which checks if the entries in column A match the value in cell D1).
  • condition2: The second condition (here, B:B = E1, which checks if the entries in column B match the value in cell E1).

Practical Example

Scenario

Assume you have the following data in your Google Sheets:

Cell References

• Cell D1: Contains the value "Apples" (the product you are searching for).
• Cell E1: Contains the value "Fruit" (the category you are searching for).

Implementation

To find the price of "Apples" in the "Fruit" category, place the formula in cell F1:

=FILTER(C:C, A:A = D1, B:B = E1)

Expected Output

The formula will return 1.00 in cell F1.

Conclusion

The provided formula effectively searches for values in two columns and retrieves corresponding data from a third column based on criteria specified in designated cells. This method enables efficient data retrieval and can be adapted to various datasets and applications.

For further learning on data analysis techniques and formulas within Google Sheets, consider exploring the resources available on the Enterprise DNA Platform.