Related Posts
Hi Fishes,
How much can I ask from BNY Mellon for the role of Lead Full-Stack Engineer.
My Tech stack: Java, Spring Boot, Microservices, React, Node and AWS
YOE: 7.5 years
CCTC: 23.71L all fixed. Have received MVP bonus of 1.6L EY Tata Consultancy Deloitte Accenture PwC ZS Associates PwC
Please do comment and put your thoughts.
Worst process to get into project in nagarro.
First go through the internal project interview then client interview if not selected then again tons of interview.Why they people take interviews at the time of hiring.
I am feeling depressed now.
In this tough time where companies are firing their employees, i am not having any project due to this pissed process in nagarro.
Joined on 1sep 2022.One more interesting fact giving interview in zs associate account(contractor) I never want to work as permanent.
Additional Posts in Consulting
GDAX fees lower than Coinbase!?
When do comp statements come out ?
New to Fishbowl?
unlock all discussions on Fishbowl.



Rising Star
Add in trim to make sure there are no leading or trailing spaces
Rising Star
idk, lemme ask my intern
Not trying to be facetious but did you set up the function properly and reference the right cells?
Chief
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()
Chief
Feel free to dm (or use Excel bowl) if it doesn't work
Make sure the lookup table is anchored !
Try not to get too stressed, you’ll figure it out
Formatting (such as word vs number), potential spaces before/after value
Chief
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.
Chief
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
Pro
If the vlookup isn’t scaled properly, sometimes the reference cells shift down each line. Just double check that