This is a method for fuzzy search (extraction) with the FILTER function.

## What is the FILTER function?

You can use the FILTER function to extract the result of a specific condition from within a range.

`=FILTER(array, contains, [if empty])`

By using the FILTER function of Google Sheets, you can extract the result of the specified value from the table.

I was able to extract the ring chrysanthemum (white) in row F.

## Is fuzzy search not possible with the FILTER function?

Even if you try to do a fuzzy search with this filter function, the result will not be returned as it is. Is it possible with asterisk? And even if I try, it will return an error (no matches).

`=FILTER(estimate_quantity_flower!A:K,estimate_quantity_flower!F:F="輪菊*")`

In this case, it is a method to realize a fuzzy search.

## Combining FIND functions

Now combine the FIND function.

`=FILTER(estimate_quantity_flower!A:K,FIND("輪菊",estimate_quantity_flower!F:F))`

The fuzzy search returned results!

## summary

Combining the FIND function with the FILTER function changed it to “contains”.

Why is the return value of the FIND function like this…? is a mystery at the moment, but by combining the FILTER function and the FIND function, it is possible to extract fuzzy filters.

Please refer to it.