Fuzzy Lookup - How to Find Similar Text | LibreOffice Calc
Vložit
- čas přidán 8. 11. 2023
- Learn how to find similar text in LibreOffice Calc using FuzzyLOOKUP function to MATCH or VLOOKUP inconsistent text data, misspells, names etc. without any add-ins and complicated build-in tools.
The function does a fuzzy match right in the cell of LibreOffice Calc (free analogue of Excel) and is similar to standard VLOOKUP.
If the video was useful for you you can always support our channel to spread more knowledge:
BuyMeACoffe:
www.buymeacoffee.com/youlibre...
Cryptocurrencies:
Tether (USDT) (TRC20): THEYaFTeZsehCYvdeBtPSqj1sNsc5mg46g
Bitcoin (BTC): bc1qejeq5gan9e9nh03ng05ujckecvlypvq5vzrj9f
Etherium (ETH) (ERC20): 0xc44b2043c17c82992ad60a0587acc5b468547dce
Ravencoin (RVN) (tiny fee): RJNtZAuPJshvSzHoYTGJXMkTuZuCjD5BcP
#libreoffice #libreofficecalc
Macro code from the video lesson:
moonexcel.com.ua/fuzzy-lookup...
A free extension "YouLibreCalc.oxt" with many additional functions for LibreOffice Calc:
moonexcel.com.ua/youlibrecalc...
A professional extension "YLC_Utilities.oxt" with many additional functions and useful utilities for LibreOffice Calc:
moonexcel.com.ua/ylc-utilitie...
If the video was helpful for you - please let me know in comments below!
Link to the function: moonexcel.com.ua/fuzzy-lookup-function-libreoffice-calc_en
A free extension "YouLibreCalc.oxt" with additional functions for LibreOffice Calc:
moonexcel.com.ua/youlibrecalc-extension-libreoffice-calc_en
A professional extension "YLC_Utilities.oxt" with many additional functions and useful utilities for LibreOffice Calc:
moonexcel.com.ua/ylc-utilities-extension-libreoffice-calc_en
З Новим роком!
This formula works perfectly in version 7.4, but in version 6.4 (Build ID: 1:6.4.7-0ubuntu0.20.04.9) the result is "#NAME?"
Any ideas?
As an alternative you can also try FuzzyLookup() from our new extension "YouLibreCalc.oxt" at the following link: moonexcel.com.ua/youlibrecalc-extension-libreoffice-calc_en