How can I request to create a new Formula?

E

Eckhard

The fomula is a mix of VLOOKUP and SEARCH:

=VSEARCH(A1;table1!A:A;2;false)

In the A1 is the Text “Shell GmbHâ€
In the A2 is the Text “Deutsche Shellâ€
In the A3 is the Text “Shell LTD.â€

In Table1 Colum A it says Shell
In Table1 Colum B it says Shell Group

The result would be that the formula would give back always “Shell Groupâ€.

The option “true†would even accept “Shel†or “Schellâ€

Thanks,
Eckhard
 
Top