Excel Lookup Value from Another Column (in another sheet) with an Exact Match

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

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

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

    This is exactly what I needed! Thank you sooo much. I don't know how many youtube videos I watched to find this information. you are amazing and the video is very concise and down to the point.

  • @jefferyparrish-l3i
    @jefferyparrish-l3i ปีที่แล้ว

    this worked wonderfully, in less than 90 seconds I solved an issue i've been hammering at for over an hour. Bravo !

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

    Thank you, I've watched numerous other videos that were much longer trying to explain this function. This one is short and sweet and gave me everything I needed.

  • @randalljordan869
    @randalljordan869 3 หลายเดือนก่อน

    Excellent video! Thank you for sharing it. I have been searching for days for this exact explanation.

  • @oghenefejiroagbi1469
    @oghenefejiroagbi1469 2 ปีที่แล้ว

    This was very helpful, I watched this video in one minute before I had to submit a report. And now I'm already vlookup-ing like a pro.
    PS that iferror part was helpful because i struggled with that before I finished the rest of your video.

  • @AmySmith-yc8vu
    @AmySmith-yc8vu ปีที่แล้ว

    So helpful. Thank you for not overcomplicating something so simple!

  • @danmurrphy3894
    @danmurrphy3894 2 ปีที่แล้ว

    Best simple explanation so far really appreciate your video and sharing!!

  • @AussieUltra
    @AussieUltra 4 หลายเดือนก่อน

    Wonderful! Short and to the point, thank you for the time saving help.

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

    You saved the day! Your tutorial gave me exactly what I wanted, thank you!

  • @itspavan-yx7oe
    @itspavan-yx7oe ปีที่แล้ว

    Thank u so much, this video reduced my time in doing data migration 😊😊

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

    YOU ARE MY HERO THANK YOU SO MUCH!!!!!!
    -Grateful sales tax consultant

  • @rc4652
    @rc4652 3 ปีที่แล้ว +4

    That's awesome! Thanks for explaining this so concisely and really well!

  • @Always_ponder
    @Always_ponder 5 หลายเดือนก่อน

    Wonderfully explained. Clear concise !

  • @h.m.j9507
    @h.m.j9507 ปีที่แล้ว

    Really concise and well explained - thanks!!

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

    Amazing tutorial, you made it so simple. Thank you!

  • @kaushalkumarllc
    @kaushalkumarllc 2 ปีที่แล้ว

    Saved me ton of work. Thank You.. I love you

  • @lchat9408
    @lchat9408 7 วันที่ผ่านมา

    Hello, I have a question. I have a certain data element that starts with RSC that I want to take that entire number and move it to another column in the same data sheet. How would I do that?

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

    that is exactly what I was looking for, thank you so much

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

    Very helpful! Thank you and God bless you.

  • @AshishKumar-sz2xh
    @AshishKumar-sz2xh 2 ปีที่แล้ว

    Thanks Ashley, you have solved my big problem.

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

    Short and precise. Thanks!

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

    It helped me alot. Thank you so much for your stuff.

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

    Thank you, this video was extremely helpful

  • @tatianagelvez3104
    @tatianagelvez3104 4 หลายเดือนก่อน

    OMG!!!! Thank you so muchhhh, you make my day

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

    thanks ashley! you saved my day :D

  • @datagrab
    @datagrab 5 หลายเดือนก่อน +1

    *Thank you ma'am. God bless.*

  • @messagehadi5942
    @messagehadi5942 2 ปีที่แล้ว

    Thank you so much for sharing this info, it is very helpful. One question, what formula or function should be entered if there is a "Product ID" in User tab, but for which there is not "Product name" or cell is blank in products tab. I had similar case and it returned value zero. How can I get rid of this zero.

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

      Hello! Sorry for the late response. I created this video while I was zoned into Excel. Unfortunately, I don't have a response off the top of my mind, but it's probably an IF statement/condition. I don't use Excel enough on a regular basis, so often times, creating a video after I figure out a problem is a good way to document for the future and to help others.

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

    Saved my life! Cheers.

  • @rohithv2198
    @rohithv2198 2 ปีที่แล้ว

    Really helpful. Thanks for the explanation.

  • @padmavathivattikonda6303
    @padmavathivattikonda6303 3 ปีที่แล้ว

    Thank you so much !! It’s really really helpful for me

  • @deprive-999x
    @deprive-999x 2 ปีที่แล้ว

    Will the table grow?

  • @E.1981-s7s
    @E.1981-s7s 2 ปีที่แล้ว

    This really helped me.

  • @nhcan92
    @nhcan92 2 ปีที่แล้ว

    Thanks. How can you find the position (row and column) of a text from other sheet ?

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

      Hello, Sorry for the late response. I created this video after I figured out a solution to my specific issue. Unfortunately, I'm not expert enough in Excel to have a direct answer to your question. I hope you were able to find a solution.

  • @michiver
    @michiver 2 ปีที่แล้ว

    Super clear and helpful! Thank you!

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

    Perfect - thanks!

  • @dhruvilpatel856
    @dhruvilpatel856 2 ปีที่แล้ว

    You are a savior!

  • @skofovacha
    @skofovacha 2 ปีที่แล้ว

    Thank you, so much !

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

    I love you, Thanks

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

    Thank you so much.

  • @veerapratap1948
    @veerapratap1948 2 ปีที่แล้ว

    If we are already mentioning A2, B17...why should we again mention 2?
    Will it not be able to count the number of columns from A, B, etc.?
    P.S. - I don't know almost anything bout Excel :)

  • @dlnorman032195
    @dlnorman032195 2 ปีที่แล้ว

    THANK YOU!!!

  • @troyg1649
    @troyg1649 2 ปีที่แล้ว

    Thank you

  • @raznjadee3390
    @raznjadee3390 2 ปีที่แล้ว

    Best❤

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

    Thank u

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

    THANK YOU!!!!