How to do an XLOOKUP with multiple variables / criteria

XLOOKUP is one of the most useful functions in Excel. But it doesn't work with multiple variables. Here I should you some workaround so that you're able to use multiple variables/criteria in your lookup.
Additional Resources:
How to standardize names in Excel: • How to Standardize Nam...
Absolute and relative references
Part One: • How to Use Relative an...
Part Two: • Mixed relative and abs...
Excel For Accounting course on LinkedIn Learning: / excel-for-accounting
Rockstar Excel website: rockstarexcel.com/
Newsletter for free tips on using Excel to make your life easier: rockstarexcel.com/newsletter/
Book a free consultation: rockstarexcel.com/book-a-free...
Theme music by Michael Gordon Shapiro: mikemusic.com/

Пікірлер: 21

  • @user-ig9gn9jo2s
    @user-ig9gn9jo2s4 ай бұрын

    LOVE THIS ONE! STruggled the whole day at work to get the logic which was in the second part!!

  • @eliphs11
    @eliphs118 ай бұрын

    This was exactly what I've been looking for for months! Thank you!

  • @keithmctaggart7663

    @keithmctaggart7663

    8 ай бұрын

    me too

  • @jaychase6828
    @jaychase68285 ай бұрын

    YOU ARE MY HERO!! 2 dimensional....couldn't figure out what I was looking for till now.

  • @TessaAnnJohn
    @TessaAnnJohnАй бұрын

    Thank you! This video was a life saver!

  • @fredkennethuy
    @fredkennethuy6 ай бұрын

    Thank you so much. I was searching for like 3 hours. This helped me a lot in my work.

  • @dandan141414
    @dandan141414Ай бұрын

    Good workaround! Love the creativity. Worked like a champ.

  • @lazaroperez4935
    @lazaroperez49355 ай бұрын

    Thank you soooooooooo much!! I was struggling with this all morning! The second part of the video is what I needed.

  • @tuyizerejeansauveur6128
    @tuyizerejeansauveur6128Ай бұрын

    Your Video is very Helpful. Thank you

  • @auctionsindia
    @auctionsindia3 ай бұрын

    you saved my life

  • @user-gw3qj9en7o
    @user-gw3qj9en7o5 ай бұрын

    This is perfect, thank you

  • @pangmichael
    @pangmichael26 күн бұрын

    Hello Sir, thank you for your share, but I have one more question, how I can set the if not found to show "Name Error" and "Month Error"? Thanks

  • @pjbourdett
    @pjbourdett4 ай бұрын

    Thank u so much for this!!!!❤❤❤

  • @pjbourdett

    @pjbourdett

    4 ай бұрын

    How can I add to this formula for no #NA

  • @jackydong4463
    @jackydong44638 ай бұрын

    Life saver...

  • @mambo0018
    @mambo00187 ай бұрын

    Hope this not a dumb quesn. But the inner-nested XLOOP gets evaluated first before the outer-nested XLOOKUP?

  • @radlock1721
    @radlock1721 Жыл бұрын

    Ok Steve, a next turn button… so the data changes to the cell you need so you can run other macos such as damage button.

  • @bluefireRyu
    @bluefireRyu2 ай бұрын

    Please show how to do it without the helper column I have too many columns as it is!

  • @azzammohamed4273
    @azzammohamed42733 ай бұрын

    love u papi . my hero . my daddy

  • @nicsa1073
    @nicsa10736 ай бұрын

    1. Improve naming conventions of the different sheets to make it easier to differentiate the sheets. 2. Focus on or Magnify areas that must be legible. 3. Instead of clicking around, it would be better to explain what is happening in the formulas. Perhaps like in this video kzread.info/dash/bejne/ZXai2KaJgc6fn5M.html