Hello,

I have a Sheet called "Customers" and column D has Customer Names.
In Sheet2 I want to search for Customer names and return all values that correspond to a partial match.
Let's say that I want to insert in cell Sheet2!A1 a string, click a "find button" and search in "Customers" sheet for a partial match and return in column Sheet2!B all the results.
Can anyone help me with this?

Tks in advance.