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 reply very soon at
Send message