Categorize Numbers the Easy Way: When LOOKUP Reigns Supreme!
https://youtu.be/IvD-l853Gi0

In 5 min, we learn how to use the LOOKUP to convert numbers into categories, e.g. translating customer spend into a loyalty type. It's simpler than VLOOKUP and XLOOKUP.

My videos have improved significantly, this is just video 4 of 50. Hope you enjoy!

Hi,
What could happen if we do not work in the current organisation after putting down the papers?
Though the LWD is yet to be received from the Manager.
Thanks

SO and I are debating contributing to 401k this year since the rate of return is around -11% on our portfolios this year. I believe it would be better off saving the cash in my account.

I'm thinking of contributing again when/if the market picks up next year. Thoughts?

Hello all.. if we travel abroad for short time - 1 month, is there any Bond in Socgen? Please advise.

Without asking or confirming, account lead booked an in-person client meeting that requires travel. Who books ~any~ major client meeting without first checking with the team ?

Anyone know when rewards/workday are likely to get updated with PA results?

I’m helping my friend put together a brand book for his startup. I’ve seen this go so many diff ways, but besides the design-related stuff, what exactly is important to include? Do I include a brand mission statement? Brand manifesto? Brand positioning? Brand tagline? Would love your thoughts.

New wage code!

Has your CTC been revised according to new wage code ? ie. Min 50% basic ?
Neither my current employer nor any offers that have been extended to me have been in accordance with this. Will our CTC be revised this FY ?

Hi All

I am having 2.7 years of experience and looking for a functional testing role
Can someone please refer me in Oracle??

Tools: Siebel CRM, Jira, Bugzilla, HP- ALM
Skills : System Testing, Regression Testing, Brm testing

Please help

Looking for a job change, Exp: 4.5 years
Role: Sr. CSR (Banking domain)
Current CTC : 4LPA
suggestion or any reference would be appreciated

Hi Fishes.. Does Barclays offer any Diwali gifts ? Just curious to know 😄

Can anyone let me know about average salary at Morgan Stanley for analyst position given I have 2 years of experience. TIA

Is it possible to get a convenient location transfer in LTIMindtree? Or it can be decided only after the project allocation?

First time investing:

1) When I sell my stocks and have capital gains, how much do I pay in taxes? %?
2) Are Boeing shares worth it?

Happy Chuseok, Fam!

Hi Friends,
Has anyone encountered direct racism as a result of Trump’s rhetoric and the usage of the “Chinese virus” despite warnings from the WHO/CDC to not do that?

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

Does 2-finger touchpad scroll not work on Excel sheets anymore? I used to be able to swipe quickly on my laptop's touchpad to navigate sheets but now it doesn't work. Based on the handful of posts I've read online about it, the problem seems unresolved. Has anyone dealt with the same issue and fixed it?

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

Best websites to get more of a handle on Excel as a beginner-intermediate?