VLOOKUP MATCH from another workbook - VBA

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

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

  • @LinhHoang-rs7ku
    @LinhHoang-rs7ku 3 หลายเดือนก่อน +1

    Excellent video Naveen.
    If your source data have more than 1 sheet, how do you handle vlookup in exactly sheet?
    Thank in advance!

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

    Too good bro... excellent video.. keep it up.👍👍

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

    Very useful video ..Thanks sir

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

    Thank you, this video helped me a lot ❣️

  • @marc-xe7ej
    @marc-xe7ej ปีที่แล้ว +2

    this is an excellent video. It is almost exactly what i need.
    workbook 1
    I have a user form that is writing a serial number to col A, then has a Combo box with drop down selection of options which are a list of the headers from workbook 2 (columns b thru J). and then col 3 is a date of completion entry.
    workbook 2
    i would like to match workbook1 serial number to the same serial number in col A workbook 2
    then match the result of col B workbook 1 to the headers of workbook 2 Col B - J and write the date of completion in the row of the serial number they entered.

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

      VLook match is not working here?

    • @marc-xe7ej
      @marc-xe7ej ปีที่แล้ว

      @@NaveenTamtaIamExcelVBA I have source data workbook - job ID in column A Column B has inputs that match my headers exactly on the master form. Column C has Dates that the task was completed. I wan to match job ID and Header to the master sheet headers and job ID (job ID Column A and headers all on ROW 1 and write Column C date in corresponding col/row.

  • @jonvesteenselvan1798
    @jonvesteenselvan1798 7 หลายเดือนก่อน

    Bro i need the vlookup in vba, as i have need same source data