How to use VLOOKUP in LibreOffice Calc

[@akhraneplex2019]

Learning to use libre please keep adding more vedios Very helpful Thanks

[@officenifty]

You're welcome, I'm happy to make more videos to help you (and others) to use Calc!

[@vinceb7918]

Nicely done tutorial video with your attention to explaining optional choices in detail in a clear voice. Please keep up the excellent effort.

[@officenifty]

I'm glad this video helped you out, thanks for the kind comment and subscribing to my channel! I really appreciate it

[@TheBeardedGamerReviews]

Great explanation thank you!

[@officenifty]

You're welcome, thanks for watching and I appreciate you leaving a comment 👍

[@healthy_palace]

Amazing video!

[@pophardie2027]

Very good

[@burhanjokhadar]

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?

[@officenifty]

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 .

[@bhmxtum]

İ wish it was possible to move with keyboard arrow keys instead of just clicking with mouse while choosing formula arguments.

[@JorgeEstrada-fn7os]

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.

[@officenifty]

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.