Playback starts YouTube’s embedded player (privacy-enhanced mode).
VLOOKUP function in spreadsheet in Libre/Open Office - tutorial - how to set it up and use it
ChannelTe MaDescription from the creator
In this tutorial you will learn:
- for what situations vlookup is useful
- how to set up and use vlookup function in spreadsheet in Libre Office/ Open Office
- that sorting has no impact on vlookup
- that vlookup is a dynamic function, and
- that you can easily copy it over as many times as you need.
This function is particularly useful to verify if the same information/value exists in two different tables or to add/merge information from two tables/places into one table.
- for what situations vlookup is useful
- how to set up and use vlookup function in spreadsheet in Libre Office/ Open Office
- that sorting has no impact on vlookup
- that vlookup is a dynamic function, and
- that you can easily copy it over as many times as you need.
This function is particularly useful to verify if the same information/value exists in two different tables or to add/merge information from two tables/places into one table.
About this tutorial
Te Ma published this 12:20 video tutorial on November 11, 2017. It has been watched 61,957 times on YouTube.
- Channel
- Te Ma
- Category
- Howto & Style
- Duration
- 12:20
- Published
- November 11, 2017
- Views
- 61,957
- Likes
- 295
Tags
Share
This tutorial in other languages
- FRfonction RECHERCHEV dans une feuille de calcul dans Libre / Open Office - tutoriel - comment configurer et utiliser
- ESfunción BUSCARV en la hoja de cálculo en la Oficina Libre / Open - Tutorial - cómo configurarlo y usarlo
- PTfunção PROCV na planilha em Libre Open Office / - tutorial - como configurá-lo e usá-lo
- ITfunzione Cerca.VERT nel foglio di calcolo in Libre / Open Office - Tutorial - come configurarlo e usarlo
- DEVLOOKUP Funktion in Tabelle in Libre / Open Office - Tutorial - wie es einzurichten und zu nutzen
- NLVLOOKUP functie in spreadsheet in Libre / Open Office - handleiding - hoe het op te zetten en te gebruiken
- RUФункция ВПР в таблице в Libre / Open Office - учебник - как установить его и использовать его
- PLFunkcja WYSZUKAJ.PIONOWO w arkuszu kalkulacyjnym w Libre / Open Office - poradnik - jak go skonfigurować i używać go
- JAリブレ/オープンオフィスでのスプレッドシートのVLOOKUP関数 - チュートリアル - それを設定し、それを使用する方法
- ARوظيفة VLOOKUP في جدول البيانات في ليبر مكتب / فتح - تعليمي - كيفية إعداده واستخدامه
- HIट्यूटोरियल - - Libre / ओपन ऑफिस में स्प्रेडशीट में VLOOKUP समारोह उसके सेटअप और इसका इस्तेमाल करने के
- IDVLOOKUP fungsi dalam spreadsheet di Libre Open Office / - tutorial - bagaimana mengatur itu dan menggunakannya