XLOOKUP is Magic: Using XLOOKUP to Generate Multiple Values
ฝัง
- เผยแพร่เมื่อ 15 ก.ย. 2024
- Download the Excel file that goes with this lesson at www.wallstreet...
In this lesson, you'll learn how to use XLOOKUP to generate multiple outputs at once, without having to create multiple XLOOKUP formulas.
![XLOOKUP with Multi Criteria Lookup | How to use XLOOKUP multi criteria? [Never seen this before!!!]](http://i.ytimg.com/vi/e7ofJ6Rz1nk/mqdefault.jpg)
My manager asked me to learn X lookup , Your video helped me so much that i can not thank you enough ! God Bless !!!!!
THANK YOU! Never would have thought to combine the result columns in the formula. This just saved me a good couple hours of work.
Usually never comments. Been looking a lot at excel videos, this one is by far the most straight forward one, nice and simple. Very good, thank you.
Nicely done! However, I'm having difficulty. I have a List of dates (columns for Month, Day, and the Event) as a single source for adding, deleting and changing if needed. I would like the ability to XLOOKUP by a specific (each) Month and have ONLY that Month's Events print at a specific cell below a monthly Calendar. Your example got me the start of the Month and its entirety, but the list aslo continued into the next Month. I must be missing something! Could you please give me a sample formula to resolve my dilemma?!
Very, very cool! Thanks!
getting #value! error. help me solve this
I have also facing this problem 😢
What if First name is not distinct and contains multiple Alicias or Luciens with different surnames?
How will it work if my criteria is not in the same sequence as the source data? E.g. in source data , Name of employee is on B coloum and Surname on C column, but i want output where Name is on C column and Surname is on B column..
How can I do this with multiple rows with the same header
waw no need to add another xlookup in the Formula!!!!!Thnak you
What about duplicate values
Life saver - reduced 16 hours of work in 6 second
Gr8 very fruitful
This is very helpful, thank you. I tried using column references (=XLOOKUP(A19#,'Assets (All)'!$Y:$Y,'Assets (All)'!$BG:$BH)) but it doesn't seem to like it, any advice?
It does kind of work, I only get the first column returned