Having an Index Match problem!

I would like to multiply the values in column C, "Company X Volume" by their corresponding Price in Column F. To do this, I know I have to index match, but I'm not sure how to do that correctly given these are not exact matches.

Any ideas?

Got asked out on a date. After I agreed he ghosted. It’s been 3 weeks and he just texted “Hey, sorry for the delay. I’m down to hang out anytime.” Is it even worth replying?

Any tips for the Duke mba interview? Is it typical behavioral questions?

Anyone from Exl.
Need to clear one doubt .Thanks in advance

Is all lean hire a reject or select ?

Has anyone here used Find Femmes or any similar dating service to find more feminine women? I’m femme4femme and am interested in something like this bc I don’t see many femmes on dating apps

Yo quiero perrear y fumarme un blunt. 😫

Does PHR certification help in India, as this is globally recognised how much valuable is this currently in indian job market.

Do we got some good offers or its another certificate just to add to CV after so much of investment & time I don't want to get this wasted !!

Need suggestions ??

I just wanted to tell you investment team assholes that we f*ing hate doing VDDs and they are hilariously when we are on the buy-side. Just stop f*ing doing them. You are wasting money. Peace out.

Jr PjM/BA 4 YOE in Tech Implementation Consulting. Beginner skills in Python, JS, HTML, CSS, AWS, SailPoint. Moderate in Azure, Okta. Have PMP, Certified Scrum Master, M.Sc., BBA. Want useful skills, but must focus energy and time. Recent projects and team just not filling my cup. Cloud Architecture, DevOps, InfoSec, IAM all seem interesting and highly rewarding. Taking CompTia N+ soon, and realizing its low demand. What certs & projects should I do to land a technical role within 1 yr?

@Hi fellow fishbowl peeps! This one is for folks who are or have been @Accenture in SM in sales capture role. Would you please help me understand a day in life for this role as well as Growth or exit opportunities? How long does it take to get promoted if you work hard and show results… How about diversity and culture? Thanks in advance for helping a fella!

Hi! Does anyone know top notch agency recruiters in the UK or Europe? Thanks!

Anyone on the east coast have an open Technical SEO position? I've been trying to transfer to the organic side of search for awhile and have good experience now.

We spend all day thinking about how to make other things look cool. If you made a :30 spot about YOURSELF, what would it be?

Looking to find housing in SF this summer beginning June 1 for 10 weeks. How does one find a place in SF for short term? It’s been a struggle so far with everyone I know at MBA...

Story time: I was on a trip about 15 years back, doing some Excel work on a ferry ride - your basic pseudo-database work that is so common. I started talking with the guy sitting next to me and after a while he commented on what I was doing, “You know, that’s really not what I designed that for…” (continued)

Is there a way to add 3+ criterias into a vlookup and if there are multiple results, to list them in different cells?

How much of a learning curve for Alteryx if one’s excel skills are advance? Or it doesn’t matter since both are totally different?

My company has locked down our Excel so that we can no longer access the VBA Editor (it’s greyed out and Alt F11 doesn’t work). However I can still access the Word VBA Editor. Is there a creative way I can launch the Excel VBA editor via the Word version, or somehow run Excel VBA code via the Word version?

Is there any big advantage of using gsheets over excel?

I have a column of numbers with a “Special” format. I need these to be a date but when I select the date option from the drop down in the number dialog box it returns as all hashtags. I tried date value, substitute functions etc but nothing seems to work. Any suggestions?

What’s your Excel horror story (worst crash, worst mistake, worst there-was-a-way-to-do-this-quicker moment)? Extra points for self-shaming

Anyone hit a manual on how to do EVERYTHING in excel 😭? PDF or something

What’s everyone’s favorite keyboard? Thinking about switching mine up

hoping this illustrative post makes sense.
column A=state; B=city. Cells in each column are drop downs, i.e.,can select countries/states. And, current dataset/selected choices is indicative of a category i.e., top locations. I want to build scenarios or addtl categories that ultimately auto changes values in the drop down cells. this is doable w/ lookups, but want to avoid formulas as i need the client to be able to customize the dataset/selections to view scenarios , hence drop downs. 😬😬

Looking to use an XIRR formula with an “As of” date option (as of 12/31, 9/30, etc…) So it would essentially stop pulling dates and values once it hits the date in the “as of” date cell.

Any ideas? Much appreciated.

Please suggest some good training material for learning macros...

Is it possible to make a VBA userform that let's me interact with the workbook? I know how to create the form but default seems to be that I can't do anything else in the workbook until the form is closed.

If i have a # set and a # that is the sum of a subset of #s, but don’t know what #s make up the sum, is there an excel/python function that will give all possible combos that cud make up the given sum

Would someone please explain in a simple way when to use an array? Is it for every index match formula every time?

What's the equivalent to a sumifs formula but instead of #s I want to bring in names. For example, i want to return a client name but only if it meets two criteria.

Does anyone know how you can create a pivot table that results in calculations being performed from that pivot table, where if the pivot table changes, resulting in more/fewer rows, it moves the formulas up or down depending on the additions/removals?
Basically, have a dataset, trying to select all rows where the answer in one column is Yes and answer in another column is (for example "X"), and multiplying the amount in another column by 16%.

Does anyone know why negative IRR sometimes gives you a NUM error? A lot of googling and experimenting but cannot pin down what’s going on.

If I have a very large pivot table with a bunch of subtotals, is there an easy way to make those subtotals actually formula driven? Other than just copying the values from the pivot into a new sheet and converting the hard-coded amounts to formulas manually?