SORT/FILTER formula

[uk747]

Cat	Red	8​
Dog	Blue	7​
Pig	Red	6​
Elephant	Green	5​
Bear	Yellow	2​

Hi
Trying to Filter A2:C100 Where Column B = "Red" and SORT 3rd Column Ascending. If Red Doesn't appear I want to use the IfEmpty Argument

I've used =SORT(FILTER($A$2:$C$100,($B$2:$B$100 = "Red")),3,1) which works, however I need to edit in case there aren't any results
i.e. =SORT(FILTER($A$2:$C$100,($B$2:$B$100="Red"),"Nothing to See HERE!"))
But when I add the Sort part to this I get a #Value! Error if Red doesn't appear in Column B =SORT(FILTER($A$2:$C$100,($B$2:$B$100="Red"),"Nothing to See HERE!"),2,1)

Result should be

Pig	Red	6​
Cat	Red	8​

 

[Georgiboy]

That's right, so for 3 columns it's ok, but it would need a different approach if there were a lot of columns.

Thanks Fluff, it helps me to understand.

 

[Fluff]

For partial match try

=SORT(FILTER($A$2:$C$100,ISNUMBER(SEARCH("red",$B$2:$B$100)),{"No data","",""}),3,1)

 

[uk747]

For partial match try

=SORT(FILTER($A$2:$C$100,ISNUMBER(SEARCH("red",$B$2:$B$100)),{"No data","",""}),3,1)

Thanks again

Managed to get close but no cigar when I tried

=SORT(FILTER($A$2:$C$20,(ISNUMBER(SEARCH("red",$B$2:$B$20),{"No data","",""}),3,1))) - Too may arguments for this function

=SORT(FILTER($A$2:$C$20,ISNUMBER(SEARCH("red",$B$2:$B$20)),{"No data","",""}),3,1) - Yours worked fine

 

[Fluff]

Glad we could help & thanks for the feedback.