Forum Discussion
Solved
Excel Filter Formula Help
MS Support Community, I have a search field that looks for specific data in a large amount of data. I have the users only able to view the columns that they need by using the CHOOSECOLS function. ...
If nothing matches FILTER returns single text value. Applying CHOOSECOLS(..., 3,4,8,9) to single value returns #VALUE! error - formulae simply can't find columns listed. Only CHOOSECOLS(..., 1) works if no matches.
Alternatively you may use something like
=IFERROR( CHOOSECOLS( FILTER(...), ....), "nothing was found" )
If nothing matches FILTER returns single text value. Applying CHOOSECOLS(..., 3,4,8,9) to single value returns #VALUE! error - formulae simply can't find columns listed. Only CHOOSECOLS(..., 1) works if no matches.
Alternatively you may use something like
=IFERROR( CHOOSECOLS( FILTER(...), ....), "nothing was found" )