Find Closest Match in Google Sheets

Author https://www.chicagocomputerclasses.com/

YouTube Channel > LGS > https://www.youtube.com/channel/UC8p19gUXJYTsUPEpusHgteQ

YouTube Channel > Get __it Done! > https://www.youtube.com/channel/UCJebzvfCuA5ymtb79DQm36A

---

Support the Developer

Patreon https://www.patreon.com/chicagocomputerclasses

One time donations https://www.chicagocomputerclasses.com/youtube-learn-google-spreadsheets/

---

Learn how to use on YouTube https://youtu.be/Ft5lxsXIGfE

V1.0

=GETBESTMATCH(A1,G:G,0.7)

V1.1

=FINDSIMILARTEXT(A1,G:G,0.7,"text")
=FINDSIMILARTEXT(A1,G:G,0.7,"position")

V1.2

=FINDSIMILARTEXT(A1,G:G,0.7,"text")
=FINDSIMILARTEXT(A1:A6,G:G,0.7,"text")
=FINDSIMILARTEXT(A1,G:G,0.7,"position")
=FINDSIMILARTEXT(A1:A6,G:G,0.7,"position")