Use the FINDIFS function to search a table column

The syntax is:

FINDIFS(column_to_retrieve_value_from, column_to_search, condition)
column_to_retrieve_value_from = the column where the values will be retrieved from (T1!A, T2!B, etc)
column_to_search = the column that will be searched
condition = the condition that will be applied on "column_to_search"
FINDIFS(T1!A, T1!B, ">10")
will return the first value in column A of table T1 for which the value in table T1 column B is greater than 10
so for the table:
100 2
200 10
300 20
400 30
FINDIFS(T1!A, T1!B, ">10") will return 300.

You can use the value of other questions like this:

FINDIFS(T1!A, T1!B, @Question)
FINDIFS(T1!A, T1!B, ">@Question")

You can also have multiple conditions:

FINDIFS(T1!A, T1!B, ">10", T1!C, 3)
This will return values in column A for which the value in column B is greater than 10 and the value in column C is 3.

You can also return an array of values that match your condition(s) - this is useful for functions that need arrays as inputs, like FVSCHEDULE:

FINDIFS_ALL(T1!A, T1!B, ">10")

IF you need to find multiple but unique values use FINDIFS_ALL_UNIQUE:


See the Tables page for more tips on how to work with tables.

Need Help?
Already checked the help docs? We're quick to answer and friendly
We'll be back with a reply very soon.
Send message