Would someone be willing to hop on a zoom call to help me figure out an Index Match formula within Excel? I’m getting a N/A error.

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

Xlookup is the way

likehelpful

+1 xlookup

Probably best to wait until Monday morning and ask one of the staff to show you the ropes on Excel

likefunnyhelpful

I didn’t mind. I work in industry, so this doesn’t happen frequently. Plus, index match saved me about an extra hour of time.

like

I figured it out. Thank you for the moral support!

likeuplifting

Go little rockstar!

funnylikeuplifting

Did you try YouTube? That’s where I get many of Excel, Tableau and Alteryx questions answered.

likehelpfulsmart

Op - way to catch it. I had this issue with a vlookup the other day and nearly lost it and until I realized everything wasn’t the same format. Glad you got it to work!

uplifting

Whenever I use these functions, I start with the “match” and make sure it’s correct. THEN, I’ll add the index to the beginning of the formula.

likehelpful

Have you tried vlookup or hlookup too?

helpful

I’m creating a table where index match would be better.

Related Posts

Within Salesforce, @Quip, Slack, Tableau Software how often are there leadership changes at the VP or above level? Is this an annual thing? X years after acquisition?

likesmart

Hi music teachers! How are you surviving? I’ve been teaching band and choir for a long time, but distance learning and Zoom has me stumped. I’m lucky to have a job, I realize. What are some things you’re doing in your virtual classrooms that your music students enjoy?

like

When is it either allowed or seen as OK to start using FTO? I recently started here and while I’m not looking to slack off and take time off, I just want to know how it works. (Plus, I don’t want to not use something that I can or should use.) Elementary stuff, I know. But I’ve freelanced my whole career until now. Thanks

Anyone that can invite me to some Slack groups for UI/UX designers and software developers for my learning?

like

Is joining cisco with 26 base 3 lk bonus and 3.5 joining bonus with 6yoe in Cisco webex good?

like

About to interview for Tech Architect role in Slack Any pointers on what I should expect in the first round?

like

I have an interview for a Principal Renewals Manager role at Slack/Salesforce this Wednesday and I was hoping for some advice on how I can wow them? Ive done a lot of research and made loads of notes but get very nervous in interviews and dont always articulate how I would want to / say everything I want to cover. It also doesnt help that the job im in at the moment makes me absolutely miserable and im desperate to leave… help!

like

Tips for helping kids stay on task during zoom? Our little class (9 kids) has been doing zoom circle times twice a week but I noticed they are really distracted. Also every meeting a kid leave...

like

Anyone interested in a zoom networking event since that seems to be the norm nowadays. Thought?

like

Currently looking for an outside sales position in Massachusetts.

I have 7 years experience in sales. But I am relocating from North Carolina to Massachusetts.

Would anyone happen to know any great companies hiring?

A majority of my experience is in the logistics and logistics technology side of sales. I’ve been working remotely doing over the phone/ zoom demo sales. But I would love the opportunity to service my clients in person!

like

Let’s finish this up strong! What are your year-end self development plans?!
We have our last session of the year of our group/guest financial education cycles at our Downtown Toronto office this Saturday. We go through our first financial education session that we talk about basic to higher level of financial information; from saving, investing, risks and returns, registered accounts, etc. There is no cost and no obligation. If you are interested to attend in-person or via Zoom, let me know.

Post Photo
like

Is there anyone that works at Slack that would be willing to give me a referral for their Corporate Counsel (Commercial) position?! I really want this job so please send me a message if so and we can work something out! TIA!

like

Hi Dance Teachers! What have been your favorite “get to know you activities” over zoom on the first few days of school?

like
like

Hi! Can someone recommend a source for learning how do simple, fun music lessons on Zoom? I teach first grade and use music for my transitions. I would also like to play songs for them with my guitar, but am concerned it won’t sound good on zoom (the guitar, not my voice, which is bad, we established that long ago)

Generally curious how many companies offer phone reimbursement? My last gig did not but the current one does. Legally it seems, all employers are required to do so if we use our phone in literally any capacity (video call, slack, teams, emails etc). How prevalent is the issue of not reimbursing phone dues?

like

Hey! Are there any art directors willing to chat over zoom? I’m a recent grad and I need some advice about jump starting !

like
like

More Posts

Anyone from Huron on the group? I see booming Oracle Cloud things on there, want to know more - Risk and Controls guy from PwC.

Hi Folks. Switching from product base to service base at level 9 in accenture in SAP Domain .
Can some1 explain how the journey starts from day 1.
Heard Noise abt client interviews , bench process,layoffs etc etc.
Need Serious Comforting advise.

like

Hi fishes,
Can anyone let me know how is work life balance in NATWEST company.what all other perks include in this company

like

Film industry fishies! After covid, what is the average of projects your company handles each year?

like

Hello Guys,

I joined
Cognizant recently, the project interview calls which I am getting is not from my base location.
I have the location constraint, should I wait for the right opportunity or raise this concern to ADP team so they can look in to it?

As per ADP policy, one should not have any constraints and take the project as FCFS basis.
Cognizant

like

Hello Fishes!
Can anyone tell me if our parents can stay with us for couple of days in the accommodation provided by HSBC ?

like

Any Tech Sales leaders have insights on how much I can expect to earn as a sales leader (director / VP) at Scale AI?

like

Anyone have any advice on how to convince an absentee owner to invest in his own business? Even just being at least present here. I've tried everything I can think of and I can't even get a text reply from the guy

like

Anyone have cheap/fast dry cleaning recs? Preferably around Denny triangle/cap hill/first hill. Also looking for tailoring so I’ll take recs for that too

like
like

any recent stamping experience in Canada?

The bowl is pretty quiet. What childcare strategies are you putting into play this busy season?

like

M7 Bschools with most scholarship opportunities for vets?

Why do you think ZS canceled the internship for the '23 batch? AFAIK they did not do this even during the pandemic. Are the full-time campus placement offers also in danger of being revoked?

likehelpful

How much hike we can expect while promoting from SA to M level ?

like

[Facebook Ads Data VS Google Analytics Data] 🤯

How can I merge FB and GA data? Some clients of mine believe that Facebook doesn't bring us results 'cause GA says so. The difference between the two of them is A LOT. Facebook says we have 100 conversions and GA only reports 2. How can I prove to them that Facebook does its job? What data can I show?

like

Would it be too much of a reach to try to go for a financial analyst position if my only experience is in compliance tax?

like

Hi,

Can someone help me with the inhand salary for the below mentioned.

Post Photo

Is your facility paying for you to get COVID
testing?

like

Additional Posts in Accounting

Happy Pride, all y’all 🌈🐠🐟🌈 out here!

like

What are raise amounts or percentages per year?

like

Has anyone worked for an accounting advisory (technical accounting) practice and FDD? Which did you like better and why?

I'm in an AAS practice but wonder if I'd like FDD more.

like

So FTX, a multi-billion dollar business, was running on quickbooks per the Financial Services Committee meeting going on right now 😂 Man their auditors gotta be sweating

likefunny

I literally almost threw my laptop. Didn't know I could be capable of such anger

like

Is it possible to make SM after being MGR only 2 years? Was 5 star rated as MGR 1 and gold standard as MGR 2.

like

Thinking joining Deloitte New Jersey office… any thoughts/reviews from anyone that works there on culture/people/workload/etc?? Deloitte

like

In person corporate financial analyst interview questions? Suggestions on what to bring?

like

Hey KPMG how is life in the FRM advisory? Got a job offer from them

like

Is CMA worth getting after getting the CPA? Or is it better to get the CFA. Also don’t have much finance background so I don’t know if I can pass the CFA will require a lot of hard work. Interesting in hearing people’s thoughts.

I have no plans in leaving PA anytime soon but I figure maybe I should look into another certification that holds value and makes me more marketable compared to my peers. Appreciate any thoughts and advice.

- Also considering going to a t14 MBA in future.

like

Will PwC Tax just come out say that we aren’t getting the “shutdown” this year rather than passive aggressively sending an email everyday saying we might not get it?

like

What’s the dress code at BDO? Jeans eveyday?

likefunny

All right people. LET'S FILE SOME TAX RETURNS.

like

Do I charge flight time to my client... or the General admin code? #newhire

like

Can someone tell me where should I put my money, Roth or traditional? Should I also contribute to hsa? How do I max out all contributions and benefits?

like

So how late have y’all been working til? 8/9 pm? My team has been doing 11 pm for weeks 💀

like

For those that work for Amazon in there accounting and tax department, what has your experience been like and how did you land your job?

likehelpful

What are you saving for?

likefunny

Is internal audit a good career path? I was presented with a position at a fortune 500 company, and I’m ready leave my PA firm, but not sure if leaving PA is right. I’m senior level

like

I’m job hunting right now, and dang none of these industry jobs sound exciting ☹️

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