I’m using VLookup to compare two lists and for some reason it does not return any values. Instead I just see the formula. No error pops up either. The same formula/logic works on other sheets. What could be wrong? I tried copying the data to a new sheet and it still won’t work

If you could live in London or Copenhagen, which would you choose, and why?

Best books for U.S. Corporate Tax similar to Logic of Subchapter K for partnerships? I’ve historically worked extensively with partnerships and starting to branch out into more “Core” corporate M&A Tax and looking for a helpful resource to get up to speed.

Any insights into the Kroll or CFGI FDD/TAS Manager interview process? Any comp expectations for NYC/HCOL M1?

EY TARAS or EY GCR??? Between these 2 service lines which has better pay and opportunities??

What’s a typical career growth route for an FP&A analyst? And outside of Business Partnering and Excel skill sets what else is needed to move up the ladder?

Hi everyone, anyone know of opening at their company that will connect? I’ve been doing FP&A work in higher Education for about 6 years and would like to break into Tech/fintech. I have an MBA and all the relevant experience (KPIs, modeling, ad box analysis etc…)

Anyone know of a good building for a 1bed/1bath. Need to have parking & a/c. Nice to haves is in-unit laundry, any include utilities, any amenities. Trying to keep it on the cheaper end with a max rent of 1,500, but given our line of work I can bump that up if the place is nice enough to justify the cost. Thanks in advance!

Selling a peloton cause I’m moving out of town in a couple weeks, ~4 months old, hardly used and in great condition, $1000 or best offer

Is there any mandatory working hours constraint in sg? Like in CTS we have to be logging hours for atleast 9 hours?

Taking the NY bar for the first time. Is it fine to take it from the work laptop because personal laptop seems to be giving up in life! Please guide any pros or cons. Thanks !

Just got an offer for a Cyber manager role in Deloitte based out of Toronto. Transferring from US as M2. HR setup time to talk salary expectations. Any feedback on salary range for cyber Ms in Toronto?

I feel like all of my friends who work in tech are very open about their starting salaries and the increases each year. I am going to work in public accounting and I feel like when I look up how much I will make after being promoted or early promoted it’s very cryptic. Can anyone tell me the standard salary % increase in PA after your first, second, third promotion?

Anyone else’s boss make them work until 630 on a Friday every single week? Please save me.

I'm looking for a comms planner for a mid-size agency in San Diego. 5-7 years overall experience with at least 1 full year spent exclusively on comms. DM me if you're interested, I'd consider more experienced as well.

Hi Fishes
I have recently joined bank of america, india branch, it's not been 15 days actually. And they are asking all the employees who are working from home to come to office. Which is 18 april. Can we as a employee ask the company to continue with the work from home model.

EY GDS Pune hiring ?

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

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.

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

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.

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

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)

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

Still don't have xlookup. #fomo

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?

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

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.

What are your top Excel ninja tricks? Ones that few people know...

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

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

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏