Any good tutorials for XLookup?

like
Posting as :
works at
You are currently posting as works at

Yes, search for “index match” on youtube

likefunnysmart

Because index match:
1. Is faster
2. Is more versatile
3. Does not have compatibility issues*
4. Can perform double directional search when adjusted for binary (equivalent to the double true vlookup)
5. [SUBJECTIVE] Is easier to understand (you INDEX something and MATCH the row/column)

* unless you go like excel 2003 or older vs 2016 (a specific build)

P.s.: they accomplish the same thing in simple cases, but they DO NOT do the same thing

like

https://www.awalkintheparkfinance.com/pagina-vuota-42

like

Very cool. Love resources like this.

like

Leila Gharani

like

On

like

Why do you need a tutorial? 🤔

like

Not for me..asking for a colleague

It’s super easy if you already know vlookup. Just google it.

like

1000% index match is better!

like

youtube

LinkedIn learning :)

=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])

If you have to ask … you can’t afford it …

ZJ

like

Index match is stronger… but xlookup is faster to navigate, and is can be one of the easiest functions to use with some practice. Reach out if you need any help!

Related Posts

Hello HR Colleagues, do not be afraid of implementing equity and inclusion strategies into your organization culture work. Wondering where to begin? How to begin this work? Should your organization hire a consultant? Is this something that a HR Professional can do?

like

Anyone here who is a CA?

Europe!
What is reasonable salary growth coefficient when going from FTE to consultant?
My current reasoning is 2x as
* We get 100% parental leave for 6 months in current company
* Risk mitigation

I have never been a consultant before, what other factors should one consider?

like
like

Larsen & Toubro Infotech Band 9 in IBM vs P6 in Larsen & Toubro Infotech . Better fixed salary at IBM . Which one to choose, need help !!

like

Anyone know the salary range for L3-L5 for a TSE position at Google? Ballpark would be good

likehelpful

Is cybesecurity as lucrative as software engineering careers.

I know cybersec covers a wide field. Any sub areas within cyber that pay more than other?

like

Hello fishes, I am looking for a part time UI UX role to expand my knowledge on a single product.
Let me know if there are any opportunities available.

like

Hey guys I’ve 3 years of US Government consulting experience in Data Analytics and reporting for decision making and I have to move Canada because of personal reasons.

Can anyone help me out with landing an opportunity? I’ve Canadian Permanent Residency.

like

How much stock do you put on benefits? I have two offers with stark differences in benefits. Job 1: role I want, but benefit sucks (2 weeks paternity leave, 20% coinsurance). Job 2: role is okay but higher level and great benefits (16 weeks paternity, 0% coinsurance, 5 more days of vacation). Total comp is the same though. I wonder if I should just focus on role but Job 2 is a large company, so I can move around after 2-3 years I’d expect. Thoughts?

like

Hello I am pursuing ACCA and also I am working in accenture and have 2.6 yrs of experience in accounts and finance profile I am actively looking for job change can any one help me please contact 9411836185

like

Anyone have any leads on a Trademark Counsel position? I'm just starting my 7th year of practice and want out of private practice. I'm in Colorado and would prefer to stay here but am open to full remote opportunities as well. Feel free to message me if you know of anything. Thank you!

like

I have an interview at a place in NY I’ve always wanted to work at. Any pointers or recommendations for how to prepare?

like

Why is it so difficult to make the next career move within your OWN company. I have over 7 years of experience across multiple departments and yet an external company is more willing to give an interview to select roles than your own home company for the same role internally!!

Where is the loyalty in that !!??

like
like

Cheaters… pleasantly surprised the yearbook ran the quote.

Post Photo
likefunny

Anyone from SaT Bangalore? Looking for help/referrals.

like

Looking to join a running club for LGBTQ folk or other agency folk. Is that a thing? NYC by the way.

Anyone know if any Tech/FAANG companies hiring in Sourcing and Supply Chain management roles?

like

Who are the top consulting firms for each of the type of work in Pharma?

Corporate strategy -
Portfolio + brand level strategy -
Sales & marketing strategy -
R&D strategy -
Transactions / M&A strategy -
Analytics -

Feel free to put more than 1 firm in each category :)

like

Additional Posts in Excel Genius

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
like

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

How do I compare two sheets to make sure they are identical?

like

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

like

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

How do you fix microsoft excel cannot paste data error?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal