why is index match superior to vlookup?

When renting a condo from an owner, I was asked to pay a $150 move-in fee to the building which I thought makes sense, but then I am being told to also pay a $500 non refundable move in fee to the owner but he is not wanting a security deposit. Is this normal? Seems like $500 down the drain but not sure if this is normal

Hello,

I have done my cyber security certificate CISSP with 9+ yrs exp can anyone tell me how can I move in to that role and how much salary I can expect l.
Thanks in advance !

PHEV (specifically, RAV4 Prime) yay/nay?

Expected use case:
Family car
Low mileage (<10-11k / yr)
4-5 days a week expecting less 30 miles per day
Weekends 100-200 miles altogether (occasionally)
Rare road trip use (1x or 2x / yr; <300 miles one way)
Have garage (to charge at home)

Chief Concern: "Best of both worlds" in engineering can mean compromises and complications, which can mean non-resilient/unreliable. But I'm no gearhead, so not sure if I'm making massive incorrect assumptions.

Does anybody know what the typical salary range is and total comp for someone starting out as an internal or external wholesaler? If you are one of these, can you share about your experience in terms of whether you liked it or not, work life balance, travel, etc?

Would you rather do Machine Learning at Big4 or Business Intelligence at FAANG?

Is anyone else pissed that our hard earned money wasn’t lost today, it was STOLEN by CORRUPT GREEDY HEDGE FUNDS

Anyways, not giving them the satisfaction. Gonna keep holding. Actually just bought the dips today for AMC BB NOK. Will keep holding for years if I have to because stocks eventually go UP📈📈📈 and ain’t no paper handed simp.

That is all
Obligatory🚀🚀🚀

Hi fishes,

I am trying to download my salary certificate from the alumni portal (2016) but the pdf is password protected. I tried entering my employee id but it is not working. Can somebody help me with the password format?
Thanks and miss infy a lot

I am doing my MBA on side. I am looking for ideas on what workshops or session series I can conduct that relates to exciting non work topics or work related (this would be boring though). If you have any other ideas throw it my way.

I’m a 9th year in a mostly litigation-based practice group at a one-tier partnership firm. My group’s billable hours have been low the last few years, so making partner will be nearly impossible, and a counsel position is not viable long-term in my group. What’s the best option here if partnership is the ultimate goal? Try to get a NEP/counsel position at another firm, which is likely difficult in my market, or offer to take a class cut by a few years?

ZS fish, possible to come in and work 50-55 hours a week? Or should I expect 60+? Interested in firm & work but just can’t keep working from 9-10 every day anymore. Wondering if I should apply or just hang up the hat and go to industry

Does anyone know what the dress code is for the upcoming CAALA Trial Skills seminar? Do people usually wear suits or is it business casual? Thank you!

What are flexi car benefits in Nagarro?
How to avail it ?

Anyone know the salary bands for a Deloitte Consulting FS senior Manager in Phoenix?

Hi Fishes,

Looking for a job in Oracle Fusion Functional role. YOE- 9

LWD- Nov 7

Please let me know of any opportunities

Has anyone ever said no to a federal clerkship and if so, why?

I’m trying to learn more about Excel functionality and there’s several simple functions that I don’t know, this is probably one. If I am color coding data, is there a way to automatically move those lines to the top or bottom of the spreadsheet once the color code for the line is made?

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 🙏

Any book recommendations on excel modeling for real world business applications?

How long did it take you to become good at excel? Like fast?

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

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

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..

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

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

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

Is it possible to round a number (say rounding $98 to $100) without losing precision in following calcs? So I only want to round visually and I want the calcs from that cell to remain off the $98 not $100

How can I update the range in one location for a tab whose data source, a second tab, is connected to SAP and the range updates on the source tab depending on quarterly activity?

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 😭

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.

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

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