How to use VLOOKUP in LibreOffice Calc
HTML-код
- Опубликовано: 2 окт 2024
- Don't waste minutes or even hours to look up values in a spreadsheet! ⏲️
In this VLOOKUP example, you'll see that LibreOffice Calc will quickly match and "look up" values in a table or dataset.
I explain the formula syntax and how each argument is used so you can implement this useful function right away.
#LibreOfficeCalc
Amazing video!
İ wish it was possible to move with keyboard arrow keys instead of just clicking with mouse while choosing formula arguments.
Great explanation thank you!
You're welcome, thanks for watching and I appreciate you leaving a comment 👍
Learning to use libre please keep adding more vedios
Very helpful
Thanks
You're welcome, I'm happy to make more videos to help you (and others) to use Calc!
Very good
Nicely done tutorial video with your attention to explaining optional choices in detail in a clear voice.
Please keep up the excellent effort.
I'm glad this video helped you out, thanks for the kind comment and subscribing to my channel! I really appreciate it
Thank you very much,
please can you explain how to use this or some other function that takes two inputs, something like floor number, room number to find resident name?
You can try to add a third column that combines the floor and room numbers. Then use VLookup using the combined column. A formula to combine the Floor and Room columns would be = A2 & B2 .
Is there a reason why Vlookup doesn't work with 3000 cells? I did a test with just a like you did, and it works, but it doesn't with all my data.
It might be too many rows and cells to use. I had this issue in Excel (when using thousands of rows).
What I recommend is to create a new sheet, and try using only the relevant 2 or 3 columns you need for VLookup. After the lookup is done in the new sheet, you can copy and paste the column back to your larger sheet. Keep in mind to maintain the same sort order of your columns before you copy and paste.