IndexMatch or DGet? My IndexMatch array lookups with multiple criteria are still taking forever even after I double my RAM to 16GB.

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

I'll google. This is worth my time

like

Do what ever you are doing in Microsoft access

like

DGet is one of the excel database functions. My questions is really... IndexMatch vs. Database functions

like

YouTube tutorials, Microsoft's website, internal web training (assuming D has an agreement with MS), just open it up and give it a try. If you have questions along the way you can post to Microsoft's forum or give stack exchange a try. It's a lot easier to learn when you actually have a problem you want to solve with it.

like

What's dget???

Option 1: if you're returning a number you could use a sum product and specify criteria using "--"

Option 2: you could make a new column next to both the data you are using to "lookup" and the data you are returning, and in that column you would put in all the criteria and return it as a true false. Then depending on what you want to do, you could do a lookup on first the t/f and then decide whether to return the the value, or you could try concatenating the true false in both the lookup and return areas and then doing some type of left/right function to determine if it met the criteria or not

Agree with access. If you're doing something that is this memory and processor extensive in excel, it should be done in access.

Any tips for learning access?
Also, I can already tell things should be structured different in access, than they are in excel. Tips on that?

QlikView. Much better and more intuitive than Excel and Access. Compression ratio also beats Excel and Access. Personal edition is free. I'm never using Office for complex analysis ever again.

Access for dummies is how I learned.

Related Posts

I interviewed with Aspire systems, cleared all rounds, the HM keeps telling me that I will receive an offer letter soon but it's been two weeks. Do they really waste candidate's time and energy like this?

like
like

Due to the weather here in Texas tomorrow is…

Post Photo
likefunny

What are the top designer brands for women?

like

Anyone hit this morning on the Jordan birthday restock?

So I’m a senior headed into law school that has two pre law programs lined up for the summer. They’re both midsized southeast firms. How can I best spring board into big law from here?

likehelpful

Anyone there ?

like

Which is your stock pick this week?
Serious answers only!

like

3 nights in Nice. Any recommendations for day trips? Thinking 1 day to Monaco, and Cannes vs

like

What experiences do you have with flip grid?

like

Does anyone have a sense of what salaries are for strategy roles for ex- consultants at the manager levels?

like

Hi,
Can anyone from
Paytm give me an idea about when will they start calling people back to offices?

like

Currently drunk, happy Friday y’all!

like

Hi Fishes,

My work location in offer letter is mentioned as B-23, Sector 58, Noida.
Is it a new office of EY because i heard that they had office in sector 126.
I am aligned to SAT team.

like

Feelings in general on Reminger and comp?

like

Just finished Indian Matchmaking. Has anyone else watched it? What are your thoughts?

like

If you had (1) a Big Law offer (year four) which would be a step up from your current firm or (2) could go directly in-house (which is your eventual plan), what would you choose to do? Get additional experience with bigger clients or move in-house?

like

Hi , i got my offer letter on 20th april and completed my bgv on 29th july. I still do not know about my joining date or onboarding status. I joined with wipro elite nth . Can anyone help?

like

Additional Posts in Consulting

If you had an opportunity to work at Stratton Oakmont at its peak, would you have taken the offer ? Just based on their culture, and knowledge about the firm at the time (not considering info available now)

likefunny

How would you explain the first two lines?

Post Photo
likefunny

How long did it take you from starting your job search to getting an offer? Laid off recently and feeling super overwhelmed/depressed

like

Those who have undergone layoffs... Our fallen sisters and brothers... What are the plans now? Would be especially interested in hearing from those not planning to go to another consulting firm.

like

How is utilization at PwC calculated? Have been told if I'm hitting my full capacity per week, it hurts utilization to charge internal codes like excess travel, g&a for other work, and training hours

like

Since WHF I stopped using my personal laptop altogether - was wondering if companies track browsing history on our work laptops?

likefunny

Currently looking for Tech consulting/ Implementation consultant/ privacy roles in London. I have both CIPP/E and CIPM.
Please let me know if you know any roles that are available? Or any recruitment agencies you can refer me to

like

Anyone have any recs for self help books? Looking for more relatable topics to myself I guess?

like

Has anyone done an all inclusive (provides housing and food) padi certification program? Looking to get the open water one and a great location that is easy to plan for. Any recommendations would be greatly appreciated. Solo traveler

like

Has anyone taken online sustainability/ESG reporting courses that you would recommend? Looking to get more familiar with the space

likefunny

What are the best consulting firms for someone that’s looking to work in the aviation industry? Can be big consulting firms with strong presence in aviation or boutique firms. Preferably commercial strategy type of projects. US based. Thank you!

like

What’s your most important skill and why?

like

When you return your rental car, take the shuttle to the terminal, and realize you still have the keys in your pocket at the TSA checkpoint...

like

Will completely forgetting about an interview and not showing up get you black listed? 😬

funny

Would it be too much if I asked my parents if I can get a small work desk to keep at their house while I live there? I'd be so much more productive.

likefunny

Is PLN 22,000 per month salary is good to survive and save some money with family in Poland?

like

Sr Manager salary at Amazon in Supply Chain? A friend wants to refer me but he has no idea what the pay band would be. It's fully remote.

likehelpful

How do you deal with being on an engagement with people who are very simply not fun to work with? And not even just not fun but actually unengaging and/or irritating to work with. Starting to see how spoiled I was with first few managers and directors.

like

You have a couple days to summarize a case study… do you go crazy on graphics or just focus on making points of case clear?

like

genuinely haven’t accomplished a single task today & can’t focus

likeupliftinghelpful

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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