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
LOVE THIS ONE! STruggled the whole day at work to get the logic which was in the second part!!
This was exactly what I've been looking for for months! Thank you!
@keithmctaggart7663
8 ай бұрын
me too
YOU ARE MY HERO!! 2 dimensional....couldn't figure out what I was looking for till now.
Thank you! This video was a life saver!
Thank you so much. I was searching for like 3 hours. This helped me a lot in my work.
Good workaround! Love the creativity. Worked like a champ.
Thank you soooooooooo much!! I was struggling with this all morning! The second part of the video is what I needed.
Your Video is very Helpful. Thank you
you saved my life
This is perfect, thank you
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
Thank u so much for this!!!!❤❤❤
@pjbourdett
4 ай бұрын
How can I add to this formula for no #NA
Life saver...
Hope this not a dumb quesn. But the inner-nested XLOOP gets evaluated first before the outer-nested XLOOKUP?
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.
Please show how to do it without the helper column I have too many columns as it is!
love u papi . my hero . my daddy
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