Xlookup Function
XLookup is an upgraded VLookup.
We use it to find data in a table or range.
We are going to combine our X-Lookup with our Min and Max function.
The formula: =XLOOKUP(lookup value, lookup array, return array)
Ours will pull the min / max person by month.
91
453 reads
CURATED FROM
IDEAS CURATED BY
Excel is used by almost all the world's companies. Here is a brief look at 10 basic functions everyone should know.
“
The idea is part of this collection:
Learn more about education with this collection
The differences between Web 2.0 and Web 3.0
The future of the internet
Understanding the potential of Web 3.0
Related collections
Similar ideas to Xlookup Function
First Class Function
In OOP we treat data and functions separately. In FP, they are all the same. We can create an array of functions, pass a function as argument, return a function from a method.
Think Win-Win
The best option is to create Win-Win situations. With Win-Lose, or Lose-Win, one person appears to get what he wants for the moment, but the results will negatively impact the relationship between those two people going forward.
The Win-Win or No Deal option is important to use as a backup....
Generation Gap and Different Values
- As our parents are from an older generation, the things and events that shaped their world and their values are quite different from what we have seen in our formative years. Every child, no matter how bright or unique he or she may be is moulded according to the adults in charge, bringing ...
Read & Learn
20x Faster
without
deepstash
with
deepstash
with
deepstash
Personalized microlearning
—
100+ Learning Journeys
—
Access to 200,000+ ideas
—
Access to the mobile app
—
Unlimited idea saving
—
—
Unlimited history
—
—
Unlimited listening to ideas
—
—
Downloading & offline access
—
—
Supercharge your mind with one idea per day
Enter your email and spend 1 minute every day to learn something new.
I agree to receive email updates