INDEPENDENT SOFTWARE JOURNAL
TrebuchetJOURNAL
EST. 2026 · DIGITAL EDITIONExplore guides
LIBREOFFICE · CALC · HOW-TO GUIDE

VLOOKUP in LibreOffice Calc: Match IDs Without Manual Copying

Use an ID as a key to retrieve matching information from a structured table.

Use an ID as a key to retrieve matching information from a structured table. This tutorial focuses on a repeatable real-world task you can test on a sample file, not an unverified performance claim. LibreOffice is a desktop office suite; application menus and options may differ by operating system and release.

How to do it: a practical workflow

Work on a copy of your files when learning a new application. The sequence below gives you a testable outcome and a way to verify the result.

  1. Step 1. Create a reference table with an ID in its first column and a value such as Price in a later column.
  2. Step 2. Put the ID to search for in a separate input cell, using the same data type as the reference table.
  3. Step 3. Enter VLOOKUP with an exact-match option so near matches are not silently accepted.
  4. Step 4. Check a valid ID, an unknown ID and an ID that looks numeric but is stored as text.
  5. Step 5. When the sheet expands, consider named ranges and newer lookup functions if supported in your installation.

Worked example you can recreate

Try this on a sample file

Assume G2:H10 contains ItemID and Price, and A2 contains an ItemID. =VLOOKUP(A2;$G$2:$H$10;2;0) asks for column 2 with exact matching. Test with an ID that does not exist and decide how to handle the error.

Common problems and what to verify

VLOOKUP searches the first column of its selected range. Unsorted or duplicate IDs can be misleading unless you enforce unique keys.

Before handing a document to someone else, open the output in the format that person will use. Check the content and key calculations rather than relying on an export-success notification.

Quick answer

Why does VLOOKUP show #N/A?

The value might not be in the first search column, or the compared IDs may differ by spacing or data type.

Official reference and download

These instructions draw on documentation from The Document Foundation. For current user-interface details, refer to the official guide for this topic ↗. Download installation files only from LibreOffice's official download page ↗.

Keep learning

Each of these related guides answers a different task, so you can move from basic setup to a more specific workflow without repeating the same overview.

Independent educational coverage. Trebuchet is not affiliated with or endorsed by The Document Foundation. This article describes documented workflows and illustrative examples; it is not a report of hands-on benchmarking or testing.