What could be the reasons a simple Vlookup is not returning any value? I am getting N/As and 0s for a lot of my cells.

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

Add in trim to make sure there are no leading or trailing spaces

likehelpful

idk, lemme ask my intern

likefunny

Not trying to be facetious but did you set up the function properly and reference the right cells?

like

Because even tho it looks like a match, maybe the match criteria is different.

Try to =target="value you're searching" and see if the result is true. If not, try to use =TRIM()

like

Feel free to dm (or use Excel bowl) if it doesn't work

Make sure the lookup table is anchored !

like

Try not to get too stressed, you’ll figure it out

Post Photo
like

Formatting (such as word vs number), potential spaces before/after value

Here's a step by step solution:
1. Stop using VLOOKUP
2. Start using XLOOKUP (if on the latest Excel version) or INDEX MATCH on older Excel versions.
3. That'll be $50.

Find a value that is returning N/A or 0 in your dataset that you know should be returning a value and analyze it. Then adjust the formula to accommodate

If the vlookup isn’t scaled properly, sometimes the reference cells shift down each line. Just double check that

Related Posts

What’s the A/S/L of Fs in here? Better yet, any Fs in the Charlotte/NC area in here?

like
like

NDAs - signed my first one as a part of a severance agreement. thinking about leaving an honest review for this company, but unsure about the liabilities that come with this. (NDA mentioned no defamation) leaning on the side of letting it go, but this employer sucked BAD and i want others to know. ik its hard to give a straight answer bc it depends on the agreement, but wheres the line between bad mouthing vs your honest experience?

like

£85000/Annum (Fixed)

Will it be too high salary to ask for a Manager(M2)-Data Analytics position in Deloitte Consulting UK?
If no, then will it be good enough for 3 people to lead a decent life in London (Like Hounslow or Milton Keyes) including a 2 year old kid. Traveling to London on daily basis.
If yes, then kindly suggest a reasonable salary range for this role.

like

How do you deal with a line manager who is focused on saving the company money at the detriment of losing trust and running the risk of employees leaving?

likehelpful

Any product managers who wouldn’t mind me DM’ing to ask a few questions? Currently a tech consultant looking to leave consulting and considering PM

like

23M Bangalore. Do ping if interested.

Hey Bowl,
I work for a late stage(ipo) start up, earlier this year we were acquired & since then they got rid of our yearly bonuses and gave us an ESOP grant.
2 RIFs later we are almost bare bones. Since we are coming up on our usual yearly evaluations many of us assumed (with multiple conversation from our managers) that pay raises and promotions were due.
In a recent All hands we found out that this year there will be no pay raises nor promotions based off merit. Is it time to jump ship?

like

Any recommendations for residential areas/ accommodations close to EY london office? Hate to commute🫠 starting soon!

likehelpful

What amount of money would it take for your current firm to retain you?

I’ll start - the balance of my student loans.

X-post

like

Any other first year associates feel like their firms don’t really appreciate how much COVID/WFH has stunted their development? I’ve been working at a biglaw firm for 5 months and don’t feel at all like a part of the team, and am extremely stressed out by the isolation of WFH most days. I’m not really sure that anyone at the firm realizes this is happening.

likesmart

I’m not naive or fresh out of law school, but I’m at a point where I’m saying to myself “Why can’t I have it all?” I’ve been offered a job for more pay and less hours and I keep thinking to myself, what’s the catch? I know people will say no promotion potential or that’s not how it works…but what if it could? What if you make yourself valuable by still setting your boundaries? Why would we resent someone who has that opportunity?

like

Noob plaintif-side L&E lawyer here—how long should I wait for defense counsel to stall on a demand letter before I start getting ready to file?

like

Wondering what people think about my situation. I’ve been offered a role with a company. The job description didn’t mention college degree as a requirement. On my CV I have a section listed as “Education” and under it I have “Business Studies” with the university name and the 3 years that I attended the course (2.5 to be exact). It’s a 4 year degree and under this I have my High School equivalent with the years I attended there. The education wasn’t mentioned in the interviews. Continued below.

like

I am relocating to Charlotte NC November 30th and on the career hunt . I have experience in HR, hospitality, social work, customer service, and education. I’ll graduate with my Master of Social Work in May 2023. I’ve been applying to a few things but no luck. I’m open to trying new career fields and to hybrid, on-site , or remote work. Please point me in the direction of a great opportunity!

like

Which is better Cognizant or Persistent Systems in current situation for 10 yoe? Please help got 5 days to decide.

like

Could you please anyone let me know which interview questions asked in Infosys interview for Oracle SQl & Power BI technology ?

like

FB 🐬, thinking about getting a monitor for my bedroom to use as a small tv. HDMI port to connect my Amazon fire stick. Any recom? What else should I look for?

like

Additional Posts in Consulting

How does your firm measure utilization? I work for a small boutique that defines it as utilization = number of billable hours/2,080 and full bonus payout occurs at 80% plus.

like

A reminder to all: we are going through very difficult times. Please help someone who has gotten laid off if you can!

like

FB 🐬, thinking about getting a monitor for my bedroom to use as a small tv. HDMI port to connect my Amazon fire stick. Any recom? What else should I look for?

like

All I want to do is curl up in bed with hot tea and a good book. Recommendations for if I ever achieve said dream?

like

Anyone care to share experiences of flying out of Stewart Airport in upstate NY? I'll be getting there from Manhattan.

like

If counselor doesn't have to present you at year end does that mean your destined for a 3?

like

Anyone else scroll through LinkedIn and constantly feel behind in their career? Everyone I know is exiting from MBB to VC/PE and I’m still making peanuts at Big 4. How do you deal with knowing you’re mediocre/less sharp?

like

What is the difference between McKinsey strategy consulting and McKinsey Digital? Is the latter still strategy but related to Digital work or do they do implementations?

like

Starting to get more involved in the project sales process - any recommendations for books or resources to develop skills in this area?

like

Love the discussions on here especially w the perspective that anonymity gives us the opportunity to voice extreme positions and polarizing disagreements that may not have been said in normal settings

like

Confronted client today about partner forcing us to travel while client site has travel restrictions. As a result is team is remote next week. Counting down days till I get rolled off/fired now lol

like

Any recommendations for good work desks - not planning to splurge (max budget: $200-300 but prefer less than $200). Just need space for my monitor, laptop, and some storage space.

like

I just applied for an Operations Director position at a Long Island Hospital. I want to take my consultant skills and make an effort to get into health care, make an impact where I live.

like

GDAX fees lower than Coinbase!?

like

Why do some people get laid off and others not? Is it always utilization? Do people typically know they're at risk before it gets to that point?

like

Ugh FFFFFF*CK just realized in my race through TSA PRE to catch my flight I left my Burberry trench coat. Anyone ever have any luck with getting a lost item back? 😭 pissed at myself

like

How is utilization calculated? What happens if we are on the bench?

like

Any book recommendations on handling office politics?

like

Stopped working and Shut my Laptop on the flight cause a baby next to me couldn't fall asleep due to the screen glare ... Felt real good! 😇

like

When do comp statements come out ?

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