FINDIFS Formula

This article explains how to use FINDIFS formulas

Sample Usage

FINDIFS(DA_C, DA_A, 1, DA_B, 2)
FINDIFS(DA_C, DA_A, QA, DA_B, QB)

Syntax

FINDIFS(find_column_reference, criteria_column_reference1, criterion1, [criteria_column_reference2, criterion2, …])
  • find_column_reference - the column reference where the first matching item is returned
  • criteria_column_reference1 - the column reference of cells to be evaluated by criterion1.
  • cirterion1 - the condition to be met by cells in criteriacolumnreference1.
  • criteria_column_reference2, criterion2, … (optional) - additional column references and criteria to test.