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

like

EY folks - anyone up for a virtual happy hour next week sometime? We could maybe use zoom?

likesmartfunny

“Just wondering by show of emoji hands if there is sufficient demand across the company for a “euphoria” (slack) channel to discuss the best show on television?”

likefunnyuplifting

Happy Wednesday! I am trying to plan with our AP and climate lead on what we can do in distance learning as a school wide event. I suggested we still host our multicultural club assemblies on zoom for the school. Anyone have experience with zoom assemblies to promote a positive climate in DL? Thanks!

like
like

The Johnson interview is via Skype. Does anyone know how it works? I booked my interview online and provided my Skype ID but there is no link shared or anything. Do I need to download Skype on my laptop and wait for the interviewer to call me? Or will there be a link to be shared with me close to the interview date?

like

My manager is a woman, and she is always commenting on how I look in front of everyone - and it just gets so weird. Ex: on Zoom calls with everyone, she’ll call attention to my outfit, or to my extensions, or to my make up when it REALLY ISNT THAT BAD! Plus we Zoom with all other guys so it’s like UGH stop making it weird. And it’s never a straight forward compliment - it’ll be like “Hey arent you cold in that shirt?” *attention is automatically on my shirt”.CONT.

like

Do our managers have access to our Slack conversations?

like

Are pharmacy schools moving to Zoom instruction too? Wouldn't be a little weird to have pharmacists who completed their degrees online?

like

I recently “came out” at my ad agency and listed my pronouns as they/them on zoom and in my email signature. I’m not expecting perfection at all and I’ve posted in Teams with helpful articles, offering to chat if people have questions.

But still, 95% of the company refuses to even address me by my pronouns, remotely try, or ask anything.

The agency itself is led by older conservative men, but I guess I expected at least some effort from younger employees.

What should I do?

likehelpfulfunny

I love teaching art but am having to teach remotely to 1150 kids, k - 5. Have about 54 amazing elementary art teachers in my district that share SO much! I could retire (34 yrs), but just don’t want to because I love what I do! Feeling like my students aren’t getting what they should because I am struggling with Zoom, Microsoft, safe YouTube, bitmoji, embedding, downloads, editing, etc. Anyone else feeling this way?

like

“virtual happy hour”with coworkers. What do you guys think about these?

like

Pro tip: always use the same teams / zoom background so that no one knows where you’re working out of , even if they force you to turn on your camera

like

Celebrating a zoom birthday tonight with some brown-drink friends. Second-to-last friend to have a COVID birthday. Can’t wait until we can celebrate in person again with some really special bottles to make up for lost time.

Post Photo
likeuplifting

Hi everyone 🎅! I'm looking to join online communities (like this one) for people in customer success. Particularly Slack groups. Anyone have any recommendations? Thanks!

Do you keep your camera on or off for Zoom meetings, when you have the choice?

like

How do you all tackle people who come back into your life when it’s convenient for them? My former friend from college has been pushing to do zoom calls with my friend group. She doesn’t live in the same city as the rest of us and before COVID, she wasn’t involved with our lives. Now that her friends in her city are MIA, she wants to reconnect with the group but she makes insensitive comments and I just don’t have interest in being her friend. How do I convey this to my friend group?

like

Has anyone had a client request zoom and virtual house showings?

like

More Posts

About to join EY. I have a very shitty personal phone. Should I buy a new one or can I use the $60 that EY gives to get a plan that includes phone payments along with plan payments

Does “Fake it till you make it” breed the Imposter Syndrome? 🤔

like

Anyone working in T-Systems here?

like

Are you eligible for unemployment if you quit because you started having heart palpitations due to stress? This job is killing me but I’m afraid to quit.

like

What’s the culture in EYP strategy and M&A finance group?

like

I have an interview Facebook (Meta) next week for a Data Engineer Product Analytics role. Can anyone comment on WLB at Facebook from a macro perspective. Ideally if anyone has insight on WLB for DE's, that would be beneficial too.

Thanks in advance for any info!!

like

Question: Who NEEDS to be on set. Who actually comes to set? My agency appears to allow EVERYONE. I’m having trouble curbing the shit show.

like

Anyone willing to refer to Google? I’m a consultant with 2 years experience looking to shift into product management.

like

What’s a “normal” number of legal alerts/blog posts for an associate to write per year?

like

Updating Resume resources and tips? What can and cannot be on the resume as a consultant? It’s been a minute clearly

like

I received a job offer with a probationary period that requires targets are met to obtain the full salary I requested. While this is not a pure sales role, biz dev and revenue are part of the responsibility of managing a 30pp department in this role.

One target requires I increase team revenue by 20% in 6 months. They haven't shared current revenue info yet, but 20% on ANY number seems really high, especially in the first 6 months.

What are some reasonable revenue increase goals you've had?

like

Wife heard how one of the partners speaks to me because he was on speaker. She wants me to quit immediately. It’s THE top firm in my sector and city. pay is great, comp some expenses, great experience

like

Need a holiday miracle that is getting my i-485 approved…don’t know what else to do besides manifesting

like

Daily Dordle 0157 5&7/7
⬜⬜⬜⬜⬜ ⬜⬜⬜⬜⬜
⬜⬜🟩🟩🟩 ⬜🟨⬜⬜⬜
⬜⬜🟩🟩🟩 ⬜⬜⬜⬜⬜
⬜⬜🟩🟩🟩 ⬜🟩⬜⬜⬜
🟩🟩🟩🟩🟩 🟩🟨⬜⬜⬜
⬛⬛⬛⬛⬛ 🟩🟩🟩🟨⬜
⬛⬛⬛⬛⬛ 🟩🟩🟩🟩🟩

like

Today I gave an interview in mindtree.It was 30 mnts round.how long it should take for getting the result?

Trivia time: without googling, can you tell who was the first Indian chef ever to get a Michelin star?

Any DC based tech start ups? I’m interested in tech but our city isn’t a big hub for it, so looking for leads!

like

I am from the US and I'm traveling to Europe next week for the first time ever. I have read that tipping culture at restaurants and bars is different over there, so I wondered if this is true and if anyone knows, how should I prepare accordingly?

like

hey, media girl with 6 years' experience, YOU DO NOT NEED A 2-PAGE RESUME.

like

Guys ds courses for 3-4 lakhs are fucking too much to pay don't go for these types of courses. The folks who teach these courses didn't take any all that is available online or refer to some standard books or videos. Even if you want to take you can take small courses for 5-10k and learn. Develop a habit of reading documentation(embrace the fucking boredom)

like

Additional Posts in Accounting

What is the salary range for an exp manager in risk in NYC?

like

Any Peloton fishes out there. Just finished a Matt Wilpers 60 minute PZE ride he talked about how he was an audit staff ! I wonder what firm 🤣

like

What’s the ny holiday party like? Do you get to bring so?

like

Anybody ever feel like they have too much on their plate?

likefunny

EY tas expanding? Got a couple switch news recently...

like
like

Which is a better career transition? From Audit in B4 to senior financial analyst or internal audit?

like
like

Ok so I've read or heard about layoffs recently from all big four except KPMG (obviously with the worst being at Deloitte and PwC and then some at EY in specific teams or sectors). Continued below:

like

So I’m an idiot auditor. I am about to promote to senior -I’ve gotten 3s on every review. I have an opportunity to move from audit to deal advisory within B4. Am I equipped to handle the new role??

likefunny

For those of you who transitioned out of accounting/audit....what do you do now? I do internal control work but have also done regular accounting. I am a CPA. I don’t feel like my work is meaningful.

like

Started in tax about 6 mon ago and I know for sure I don’t want to do this anymore.I want to be in tech (have a degree in accounting) is there some type of certification i can do? I want to be in advi

like

My calculator is talking my back to me....

like

Any advice trying to negotiate an apartment price in NYC?

like

I'll only drink the koolaid if it comes with a shot of vodka.

like

I feel like I have no actual friends in my home office. I only go out after work with the team that I'm on. I'm in no groupchats or anything. Will this hurt me in the long run?

like

Why is secondary employment so frowned upon in our profession? I understand if you are a tax a manager at Big4 and directly competing with your firm by doing taxes on the side but what about...

like

Questions to tax manager during a potential switch to another firm?

like