It's like some days VLOOKUP just doesn't want to work! I couldn't get it to pull the data, clicked in a bajillion times and then it just randomly starts working. I swear Excel gets an attitude sometimes lol.

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

XLOOKUP

like

Agree, ditch VLOOKUP and use XLOOKUP.

like

INDEX(MATCH)

smartfunny

Why use vlookup? That was obsolete at least 10 years ago.

likehelpful

I know xlookup is the thing but vlookup is almost muscle memory for me now. It is a hard habit to break

VLOOKUP was the first lookup I learned. I get it. But it is so incredibly fragile. INDEX(MATCH) was more stable, but the syntax is not intuitive.

XLOOKUP? Life changingly awesome. Do yourself a favor and break your VLOOKUP habit. XLOOKUP is easier to write, easier to read, easier to troubleshoot.

Related Posts

I am looking for permanent wfh in Presales or sales administrator can any one give me job referral

likesmart

Hello folks,
I am a Engineer worked as plant operations Manager for 6 years and 1 years as Branch head sales.
Any JOB LEADS for me ?

Hey all,

My husband planning to make a switch from Channel sales (FMCD) to corporate sales/business development/ Strategy, can you please let me know how it can be done? Share your experiences..

like

Dear fishes ,
I am looking for job change in sales currently working in think and learn pvt. Ltd.(Byjus). As business development associate. Kindly recommend .

Hi fishes,

A quick glimpse, I have almost 3 years of working experience in sales. The first 1.5 in a ed tech firm and the rest in a IT services firm as a lead gen.

My salary is 5.5 lpa now. I would like to ask the seniors in this field to suggest me what are all the possible career transition I can do to earn better. Reason is my family business is shut and I'm the bread winner plz suggest.

I have interest in BA and marketing field (know SQL and power BI not having working exp though) help??

Anyone here offering to give feedback for HBS + GSB essays? Would love a third party opinion. Happy to pay a fee too, of course.

like
like

Interested to know: how nervous do you feel about losing your job during these strange days? And do you feel like your company is taking advantage of that at all, knowing you won’t leave?

like

How feasible to change role at Visa inc

like

Anyone knows if Singapore trash collection separates waste into recyclables ? If not, how can we do it ourselves in sg?
I live in a condo FYI.

like

Moving into a new role to support marketing efforts of two smaller divisions under our brand umbrella. When I asked my boss what the job description was to create year end goals they told me to write one. . . Where do I start?

like

What is the notice period if left in probation period?

like

Hi
Anyone facing this issue?

Post Photo
like

Bain & Company Are consultants for the CPG practice area/having CPG clients travelling yet? McKinsey & Company Boston Consulting Group Bain & Company

like

What do you think would be the best office & sector to work in ?

like

Anyone here work on Microsoft Word as a PM? Why can’t you autosave a doc regardless of it being in onedrive/hard drive/other cloud location?

like

Can I waive into other UBE jurisdictions using my NY UBE license at any time? Or is there an expiration date for my bar exam score, after which point I won't be able to waive in?

like

What's your favorite restaurant in Houston, hands down? I'm trying to test out all of the best spots before I move! Please drop your favorite

like

How is Cisco 5G development project ,Is it worth considering or rather go to security in F5 networks

like

Amy’s recs for best hot pot in Manhattan? Thanks!

like

Additional Posts in Excel Genius

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

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

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)

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

Would anyone be willing to teach me vlookup?

like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

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

like

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

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

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 I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

like

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

like

Still don't have xlookup. #fomo

like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

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

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

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