How to do a VLOOKUP in LibreOffice Calc

In this tutorial you will learn how to do a VLOOKUP in LibreOffice Calc. Vertical lookup can search hundreds of rows in LibreOffice Calc and return a corresponding value based on defined criteria.

Check out these programs I use for YouTube

Follow me on social media:
Twitter: @melissaecompton
Instagram: @melissaacompton

This description contains affiliate links and I may be paid a small commission should you purchase using these links.

#melissacompton #libreoffice #vlookup

[MYCOGROUPSBHRDEPT]

thanks melissa for preparing such good info here. really help in my work.

[malgorithm]

You are an excellent teacher! I needed the VLOOKUP fn for a fun project and you cracked it for me in 10 minutes flat! Thank you. 🤓

[jrace]

thank you for the excellent tutorial! It was very helpful.

[ender]

Thank you. I was getting error and now sorted.

[loftus]

Clear, simple explanations. Well done.

[PerEng]

Brilliant with a description using both fx and manually.

[Elvizapata]

great more please it help me a lot, shalom

[raghunathgiliyaru]

Hi Melissa, this is a nice tutorial!
I was wondering if the "vlookup" function works the same way between 2 workbooks (files)?
When I tried it did not work! So, I copied the "array" data into the same file and it worked.

[santiagobetancurbetancur]

Hello. I need to create a file to order products. That is, it fills in the order number, date and totals boxes automatically and with lists of customers, products, prices and quantities to fill out. with a print button that creates a pdf file for each order.

[HarrisHome-kg]

This is almost what I am looking for, I have a sheet that has bills do in say "January" I want to return all of the Bill name, and Amounts due in January. is this possible? It would be a filter command in excel but I can't find it in Libre Calc.