Does EY’s version of excel have Xlookup? I don’t see it

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

I was able to get office 365 upgraded and now have x lookup. I put in an IT ticket, not sure if you can do it without one

like

Just use INDEX/MATCH unless everyone who will be using the workpaper also has XLOOKUP, otherwise it will cause issues.

It’s office 365 that has the xlookup capability

Just open a tech support chat and tell the IT person you NEED the newest office 365 version on your computer to do your work. That's what I did and my laptop was updated quickly.

Related Posts

Hi Nokia folks! need your help. I am thinking of switching from Deloitte USI to Nokia is it a good idea? would you recommend it?
tech: azure data engineer
yoe: 3
What salary range can I expect? Hike and other benefits?
Thank you!

like

Hi fishes, DM for referral.

Category Manager, Technology
Location: Lowell - Massachusetts - United States, Weston - Florida - United States
Function:: Procurement

Post Photo

Hi all , can anyone please tell me where pwc hyd is allowing employes to work from office voluntarly ? At present

What have your dating experiences been like as a single teacher? I feel often times people do not see my job as challenging or understand my passion

like

Hi All,
I came across the Computer Vision Developer (R&D)and AI/ML Engineer role at Bosch and am interested in applying. Would you be providing the referral since I am interested in these roles? 

TIA

like

Hello 🎏 .. I recently got selected in Amazon for L4 position in Bangalore location for the role HR Specialist US ..my recruiter said i can expect a CTC of 7.7lpa and my current CTC is 4.75lpa..he requested for my salary slips nd other things to give me the exact num..Please advise how much I can negotiate here .I am looking for more than 11-12lpa minimum .. i have total 4 Yoe and currently in Chennai but if they ask me to wfo i dont think the mentioned pay will be sufficient. Amazon India

like

Has anyone applied for US citizenship? Is it advisable to apply 90 days in advance or wait for 5 yr tenure? Would you prefer to submit the form online or via mail? What is the current cycle time?

like
like

Hey guys..

I couldn't see any last date to accept the cts offer.

Could anyone let me know if there are any minimum days that we should accept the offer ?

like
like

So how many coworkers have discussed Meghan Kelly this week? And how awkward was it listening to that conversation? PS- idc is I spelled her name wrong. Megan, Meghan, meggann 🤷🏾‍♀️

likefunny

Desi 🐠 from Chicago: Do you have a recommendation for a good tax attorney around downtown to file taxes. Someone with knowledge of tax implications of investments in both US & India. Thanks!

like

Starting as a PM on the Walgreens innovations department team in a few weeks. Any current employees with some insight of onboarding and the day to day?

like
Post Gif
like

Looking to make the jump into a tech company as a CW. From LA/OC moving to the Bay. What’s a reasonable salary? 5 years experience as a bilingual CW.

like

Let's talk salary! What is your title, salary, location, years of experience and do you feel you are fairly paid?
For me: Director of Operations, $60K, Austin, TX, 4 YOE, & I feel I am incredibly underpaid.

like

What do you do, where are you located, and what's your salary? If you feel comfortable sharing. Just interested in the demographics of the bowl.

I'm a healthcare recruiter wfh in San Diego and I make about 56k annually.

like

How much access do equity partners have to their firms financials? I imagine that it varies firm to firm, but I imagine that all of them have some accessibility??? Anyone have any experience here?

like

Hi guys, any good MBA admission consultant to recommend ? I’m aiming for top European MBAs (INSEAD, LBS) + 1 or 2 M7 universities. Thanks !

like

What job title would you use for someone who is responsible for assessing current skills gaps in the enterprise, leveraging talent marketplace and AI to identify the current skills of the workforce, and support strategic initiatives surrounding talent planning/forecasting? Something that wouldn’t include Talent Management or Workforce Planning in the title.

like

Additional Posts in Excel Genius

Hello for some reason I can’t get my value filters to work to filter sales greater than 0 in a pivot table as seen below. Every time I try to apply it, nothing happens. I tried to filter GM and GM % but no luck as well. Any idea?

Post Photo
like

I have a large dataset and when I filter, I keep getting up pop ups that say “fixed objects will move”. How do I get this to stop?

like

Not Excel but Outlook: anyone know how to make it so others can’t recall messages from your inbox?

like

Hi all, I want to calculate duration in hours between x date/time and y date/time (dd/mm/yyyy 00:00 format). The part I need help on is how to build in logic which ignores certain hours of the day from the hours figure that we get at the end. E.g. without this built in, 0000-1900= 19 hours, but if I want to build in logic that only counts duration of hours between 0800-1700, we would get the answer of “9” even if x = 0000 and y = 1900. Would appreciate any guidance on how to do this.

like

Need some excel help. I have a report that includes data for a bunch of accounts. However the report does not include a column for client name for each account. I'm waiting on our software engineer to pull the report but in the meantime I need to figure out a way to get the existing data to include the client name.

If I have a report with all accounts and client names and the second report with the data with the account numbers, is it possible to get excel to find the associated client name

like

Would you rather use Excel versus CRM to store data and manage records? If so, why?

like

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?

like

Is there an easy way to create flow chats and diagrams in Excel without the Visio add-in?

like

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?

Post Photo
like

Is there a way to add trend lines/fitted lines for each category on a bar chart? Looking for something similar to below.

Post Photo
like

Wait … xlookup is basically VLookup and Index/Match?

Is this seriously a viable alternative because what the hell have I been doing with my life?

likefunnysmart

To all heavy Excel users, what brand laptop are you using and how’s it working for you?

like

Time to convert to xlookup

Post Photo
likefunny

What are your favorite excel macros to make you more efficient at work?

like

Hello Excel champs , need your help with the below screenshot. First table contains the master data with Parent and Child item details. Agenda - is it find out all the child items pertaining to make 1 unit of the corresponding parent item. In this example I took Parent Item A and exploded all the Child items and the required units to make 1 unit. Now the challenge is that I have a master data of 250,000 line items and I am trying to figure out the exploded version of all the Parent items.

Post Photo
likesmart

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.

like

Need to create an P&L for a physical therapy center without using existing excel templates. Just cap payment info, lease price, team member salaries and supply costs.

Seeking formula support…,and open to other tips and tricks.

Just created my first macro! Super proud of myself! #humblebrag

likeuplifting

Anyone know of an excel Add-in (preferably free) that lets tracking formula in a cell?

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