Google Sheets: Return best matching text string from a column of text strings-CodePudding

Home > other > Google Sheets: Return best matching text string from a column of text strings

Google Sheets: Return best matching text string from a column of text strings

Time：02-04

Let's say we have the name "Giorge", I'm looking for a way to return the best matching name from the table of names below:

CodePudding user response：

try:

=SORTN(A2:A4, 1, 1, LEN(REGEXREPLACE(A2:A4, "["&B2&"]", )), 1)