TOP
# FuzzyLookup function for LibreOffice Calc

## FUZZYLOOKUP() Description

## Main Features Functions FUZZYLOOKUP

### Syntax:

### Parameters:

## Example Usage

## Extension "YouLibreCalc.oxt"

We all know the well-known VLOOKUP() function that helps us combine data from different tables. However, this function has one significant drawback - it cannot combine similar values, that is, if there is an error in the word, then there will be no match.

Let's imagine that we have two lists. Both have approximately the same elements, but they may be written slightly differently. The task is to find for each element in the first list the most similar element from the second list, that is, to implement the search for the closest most similar text.

The FUZZYLOOKUP function selects values with the least number of operations needed to convert one text to another.

```
=FUZZYLOOKUP(LookupValue; LookupArray)
```

- LookupValue: The value we are looking for.
- LookupArray: The range in which we search and return the most suitable value.

The FUZZYLOOKUP() function is easy to use. You just need to specify the value we are looking for and the search range that contains approximate values and LibreOffice Calc will automatically find and return the required result:

=FUZZYLOOKUP("Adobe Systems Inc"; {Lookup Array})

We will have the following result:

This example uses the following values:

- LookupValue: A3 - The value we are looking for
("Adobe Systems Inc") . - LookupArray: A18:A32 - Range to search with approximate values
({Lookup Array}) .

You can use the function FUZZYLOOKUP() by setting the extension " YouLibreCalc.oxt ". After that, this function will be available in all files that will be opened in LibreOffice Calc.

- 1. What is VBA, basic concepts.
- 2. Debugger (Debugger)
- 3. Working with sheets (Sheets)
- 4. Working with cells (Ranges)
- 5. Properties (Properties)
- 6.1. Data types (Variables)
- 6.2. Data Types (Continued)
- 7.1. Conditions (Conditions)
- 7.2. Terms (Continued)
- 8.1. Loops (Loops)
- 8.2. Cycles (Continued)
- 9. Procedures and functions
- 10. Dialog windows
- 11.1. Workbook events
- 11.2. Worksheet events
- 12.1. Custom forms
- 12.2. Controls (Controls)
- 12.3. Control elements (Continued)
- 12.4. Control elements (Exercises)
- 13.1. Arrays (Arrays)
- 13.2. Arrays (Continued)
- 13.3. Arrays (Exercises)
- 14.1. Using Excel functions
- 14.2. Creating a custom function

- 1. SQL language, basic concepts.
- 2. Data selection (SELECT)
- 3. Data sorting (ORDER BY)
- 4. Data filtering (WHERE)
- 5. Use of metacharacters (LIKE)
- 6. Calculation (calculation) fields
- 7. Data processing functions
- 8. Data grouping (GROUP BY)
- 9. Sub-requests
- 10. Combination of tables (INNER JOIN)
- 11. OUTER JOIN
- 12. Combined requests (UNION)
- 13. Adding data (INSERT INTO)
- 14. Creating tables (CREATE TABLE)

- Import of currency rates from the NBU website
- Sum written in English
- Unpivottables (Unpivot)
- Function
Google Translate - Camel Case Function
- Snake Case Function
- Kebab Case Function
- Break Case Function
- Sentence Case Function
- Title Case Function
Fuzzy Lookup Function- Function GETSUBSTR
- Free extension "YouLibreCalc"
- Professional Extension "YLC Utilities"