Скачать или смотреть How to create a Vlookup and Hlookup formula in LibreOffice Calc

This video explains how to create a Vlookup and Hlookup in LibreOffice Calc. This is a LibreOffice calc tutorial covering, Vlookup, Hlookup and the IF function. The tutor starts off by creating a simple Vlookup using named cells and ranges. The tutor repeats the process to demonstrate how to create a Hlookup function. Hlookup stands for horizontal and Vlookup stands for vertical lookup. The tutor mentions it depends on how your data is displayed as to whether you use Hlookup or Vlookup. The tutor explains that the IF function is there to hide the N/A error message if there is no data to lookup.
#vlookup
#hlookup
#calc

Join this channel to get access to perks:
   / @itseasytraining1st  


If you want to support me, check this out:   / itseasy  

Online training courses:

https://itseasytraining.teachable.com/
https://www.udemy.com/course/microsof...
Playlists for this channel:

Access:    • Unleash the POWER of SUBMACROS in Access!  

Excel:    • Link web based data into Microsoft Excel  

Word:    • How to use Microsoft Word's mail merge fea...  

Visio:    • How to create a basic network diagram in M...  

Project:    • How to use Baselines and custom reports in...  

PowerPoint:    • Zoom feature in Microsoft PowerPoint, New!...  

Publisher:    • How to set or create Business information ...  

OneNote:    • OneNote Overview, linking into Outlook tas...  

Office 365:    • Видео  

#itseasytraining

Classroom based courses can be arranged at https://www.itseasy.co.uk/

Courses are available through Microsoft Teams, Online and Face to face in the UK

Online courses at https://itseasytraining.teachable.com/

Udemy Courses https://www.udemy.com/user/stephen-sa...

Training Guide Books

Excel for New Managers
https://www.amazon.co.uk/Excel-New-Ma...

Microsoft Project Overview https://www.amazon.co.uk/Microsoft-Pr...

Microsoft Visio Basic https://www.amazon.co.uk/Microsoft-Vi...

Very cheap E_books are here:
Excel For New Managers https://payhip.com/b/IE4x
Microsoft Project Overview https://payhip.com/b/wY0m
Microsoft Visio Basics https://payhip.com/b/5XeV
Microsoft Access Introduction https://payhip.com/b/ynSL
A PowerPoint Overview https://payhip.com/b/YkQv