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

Really don’t understand people who defend the Chicago cops. The teenager at no point tried to threaten them and we encourage gun ownership in this country.

Own a Sub 41, but getting a Hamilton Khaki Field 42 as an everyday later today! As excited as I was picking up the Sub 😍 Thoughts as an everyday watch? Will post pictures if I pull the trigger!

Hi everyone, I am looking for a new opportunity in healthcare consulting or operations. I have 7 years of healthcare experience. Education: MPA - Healthcare admin, CPHQ, working on LSSGB. I have expertise in quality improvement/management, gap closing strategies, provider education and process improvement (workflow wizard). I have been looking for my next step to no avail. I would be very thankful for any leads! Open to DMs as well.

Anyone in dc? Let’s get fucked up

Hi all- new to fishbowl. Not really sure how to use and explore the app yet but I saw this bowl and figured I would introduce myself. I am a wholesaler for 401K and I am able to partner with advisors who currently uncover 401K opportunities or are looking to learn how to. Reply if you are an advisor in the NYC area and interested in learning about how to expand your business.

Thank you to all those that are joining! Hoping to create a space where we can all give practical advice and discuss working as legal professionals in the public accounting field!

Tinder or Bumble?

I work at a surety agency and we would like to branch out into P/C commercial lines. Anyone know anything for sale? Or where to look?

Can any one refer me to Mercer for java technology?
Yoe: 2 years
Skillset: java springboot, microservices, Rest API, Hibernate.

A detailed experience in Contact center of 12 years

Any ideas on L5 process excellence manager salary range at GOC Hyderabad ?@

Which agencies have the best in-house departments?

Can someone private message me about the difference between writing H1 and H2 SEO copy vs H1-1 and H1-2 SEO copy. I am confused.

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

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).

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

How do I compare two sheets to make sure they are identical?

Hi there,
Which Excel courses you recommend for a beginner?

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

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

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!

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 ...

Any book recommendations on excel modeling for real world business applications?

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 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?

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?