I’m doing a simple IF lookup, if A = B, if true Yes, if false No. it works correctly for 90% of the table but there are a few it shows as false. When I did a simple does Cell A = Cell B to see if any issue, it shows as true. Why is my lookup acting funky?

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

Are those cells in the same number format? Or any extra spaces?

like

Found my issue. There were multiple lines with the same identifier, each with different lookup values. Thanks for your help

like

Did you lock the cell reference ranges if you have any in your formula?

Yes all references are locked

Related Posts

I have been offered 17 lpa fixed+ 75k joining bonus from PwC kolkata with current ctc 13.08 lpa in tcs. Recently I got a promotion and ctc increased to 15.03 lpa and I shared the promotion letter with pwc. They said I will get a call for offer discussion again. Could anyone tell if pwc will really revise the offer and how long will it take? How much ctc should I ask for?
Yoe - 8.3 years, sap fico
Designation offered - Senior associate

Is there Anybody who still does backend in php (laravel) and MySQL like I am doing,

Should I change my tech stack now

like

Buying vs. renting...?

like

Anyone have connections at Slack?

Best tea to drink when you have COVID?? Throat is killing me :(

Tomorrow is the first day of the new work week. What are your goals for this week?

like

I have a second interview next week for a senior occupational therapist position at Kaiser Permanente in the Bay Area. I asked the rehab supervisor who interviewed me what the salary was but she said she didn’t know and that was later down the line. Can anyone here give me a range of what I can expect/ negotiate for

like

Joining Deloitte as a SC tomorrow, based in London. I have 5 YOE in industry and will be joining the Analytics and Cognitive ( Data modernisation ) practise.
Any tips someone new to the consulting world ?
What are the expectations at SC level ?

TIA

like

Question on Coinbase transaction- when I buy or sell, does it take the price at that very moment? Any transaction charges?

like

Kirkland Sauvignon Blanc is the best value in wine. Fight me.

likefunnyhelpful

Hello fishies,
So I joined on Oct 17th so how many leaves will I be eligible to apply?.Can someone help? A fresher so no idea how it works.

like

What’s the comp. like for senior tax associate at KPMG? TIA

like

And finally I can sleep better for 4 days! Happy thanks giving to me! 😊🍺

like

Side hustle or startup ideas for someone who isn’t technical/doesn’t code? Where should I look or where to begin? I don’t have any strong passions or specific skills that I’m confident in. What books, articles, blogs, orgs, events, people I should follow for inspiration that has helped you? I have some cash to invest and am looking for a part time hustle that can cash flow at least a little bit of money on the side.

like

Any tips for negotiating salary? Details in comments

like

What’s the fewest number of days needed for IVF Stim injections? My wife is currently on day 5, so just curious what others have experienced. Thanks!

like

So, what’s private banking all about? Differences from investment banking, hierarchy, compensation structure, work-life balance, etc.

like

Any insight on writing assessment round for Amazon?

like

How is WFH policy in the amazon? Are they calling employees or do they have any plan of calling people soon?

likehelpful

How long does it take USCIS to approve Expedite request after submitting additional evidence for expedite?
I need to expedite my case due to an emergency and they requested additional information which I submitted today. Whats the time estimate for receiving a response?

like

Additional Posts in Excel Genius

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

likeuplifting

I have three lists. Each is a list of processes. Each list represents one hierarchy level. Is there an easy way to get from three separate lists to one list ordered like shown on the right?
Thanks for your help fish!

Post Photo
like

Hey Geniuses! I apologize in advance if this question has been asked before, I'm new here and just trying to learn as much as i can. Does anyone know a great source to learn Macros for beginners. I would like to create one for work. I appreciate it

like

I have a field in excel that represents the GSID, that I want to concatenate to create a link. Example field GSID is 123-west and the link needs to be www.website/123_west.html for some reason using concatenate with left & right formulas to switch - to _ results in the field throwing an error. Anyone knows of a way to make this work?

like

Last cell question. Some of my simple models are massive in file size because every tab has a last cell of ~XFD65. But I’m not using anything past ~U100. Continued.

like

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

At my old firms when I would be using excel and modeling using the font schemes (blue, green, black for hardcode, link, and formula) I could use the “control shift ;” to shift through the schemes. My new firm doesn’t do this. Does anyone know why the shortcut would be different and how I can add it back?

like

Is Macabacus or any other add-in actually worth it for Excel & PPT? In LMM - MM M&A roles.

likehelpful

What are the most typical models you all build

likehelpful

What are the most annoying things for you in old-school excel users?
I’ll start:
1) vlookup 2) concatenate 3) inability to work with file versions, therefor constantly locking file from changes

like

Can anyone help me with this pls? I created a graph using data above (not shown) but for some reason “technology” here appears three times. I want sectors to be grouped together. Is there any way to fix this?

Post Photo
like

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

like

I am having difficulties getting my (Return on ad spend) column displaying correctly. The source data is shown in currency but on the pivot table I am only seeing count and percentage options. Any help would be greatly appreciated.

Post Photo
like

Any recommend courses (coursera, edx, etc.) people would recommend for user with intermediate experience with excel?

like

What is y'all's preferred clipping tool? One of my former companies had a great simple program that was only like $50 and worth every penny.
Snipping Tool just ain't cuttin' it (lol pun intended).

like

Hey, tips for where to look for good excel cheat sheets online? :)

[shortcut genius] how can I use a keyboard shortcut to simulate the double-click on the cross in right low corner that extend your formula only to the row you need (ctrl+d will go too far)

likehelpful

Is there a way to consolidate non numerical data from multiple excel sheets into one master sheet?

like

Anyone know if / how to have the CapIQ and SNL (MI) excel plugins running at the same time? I always run into issues with one of them not functioning when they’re both enabled

Our system is really lacking and we do a lot of work outside of it to track data. Currently I’m using Excel to track data from multiple resources, however, it’s so manual and prone to error. Any suggestions to keep the data clean when I have to pull info from multiple places? I’m constantly auditing and we won’t even look at getting a new system until next year :(

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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