How to do a VLOOKUP in LibreOffice Calc

แชร์
ฝัง
  • เผยแพร่เมื่อ 7 ก.พ. 2025

ความคิดเห็น • 15

  • @malgorithm123
    @malgorithm123 9 หลายเดือนก่อน +1

    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. 🤓

  • @PerEng2405
    @PerEng2405 2 ปีที่แล้ว +2

    Brilliant with a description using both fx and manually.

    • @MelCompton
      @MelCompton  ปีที่แล้ว

      Thank you! Glad it was helpful!

  • @jrace2718
    @jrace2718 ปีที่แล้ว +1

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

  • @loftus49
    @loftus49 2 ปีที่แล้ว +3

    Clear, simple explanations. Well done.

    • @MelCompton
      @MelCompton  ปีที่แล้ว

      Thank you! I'm glad it helped!

  • @Bhavyakash
    @Bhavyakash 2 ปีที่แล้ว +2

    Thanks for the video. 👌

    • @MelCompton
      @MelCompton  ปีที่แล้ว

      Thank you! Glad it helped!

  • @santiagobetancurbetancur4406
    @santiagobetancurbetancur4406 11 หลายเดือนก่อน

    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-k8g
    @HarrisHome-k8g ปีที่แล้ว

    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.

  • @raghunathgiliyaru6316
    @raghunathgiliyaru6316 2 ปีที่แล้ว +2

    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.

    • @MelCompton
      @MelCompton  ปีที่แล้ว

      It does but it's a little bit trickier. I will put out a quick update on how to do this as soon as I can.

  • @Elvizapata
    @Elvizapata 2 ปีที่แล้ว +2

    great more please it help me a lot,shalom

    • @MelCompton
      @MelCompton  ปีที่แล้ว

      Thank you! I'm glad it helped!