Forum Discussion
Solved
Finding the column name for a value in a table
I have a 3x3 table with a header and two data rows as below. A1=First, B1=Second, C1=Third A2=1, B2=2, C2=3 A3=4, B3=5, C3=6 In cell D1 I'd like to enter a search criteria. For example 5. Th...
IF value is in one or more than cells than i want to show all the column name that have value
If you want the result as a comma separated list you could use
= TEXTJOIN(", ",,IF(data = searchCriterion, header, ""))To obtain a list
= TOCOL(IF(data = searchCriterion, header, NA()),3)Each formula tests every cell of the data table and uses a function to filter the results.