I’m using VLookup to compare two lists and for some reason it does not return any values. Instead I just see the formula. No error pops up either. The same formula/logic works on other sheets. What could be wrong? I tried copying the data to a new sheet and it still won’t work

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

Your cell is formatted as text. Change the cell formatting and then hit enter and try again.

like

Yep this

Yes probably formatted to text should use general or numbers and make sure to do trim and clean the list

like

What exactly was the issue?

Use xlookup

like

100 💯

I would also use xlookup over Vlookup if your excel version allows

like

Any good resources to learn?

like

Cell is formatted as text, update cell format, enter formula and click enter

like

Seems like everyone have had this issue before huh

Press Ctrl + ` (grave accent key, usually located to the left of the "1" key on your keyboard)

Shortcuts are live savers

Related Posts

If you could live in London or Copenhagen, which would you choose, and why?

like

Best books for U.S. Corporate Tax similar to Logic of Subchapter K for partnerships? I’ve historically worked extensively with partnerships and starting to branch out into more “Core” corporate M&A Tax and looking for a helpful resource to get up to speed.

like
like

Any insights into the Kroll or CFGI FDD/TAS Manager interview process? Any comp expectations for NYC/HCOL M1?

like

EY TARAS or EY GCR??? Between these 2 service lines which has better pay and opportunities??

like

What’s a typical career growth route for an FP&A analyst? And outside of Business Partnering and Excel skill sets what else is needed to move up the ladder?

like

Hi everyone, anyone know of opening at their company that will connect? I’ve been doing FP&A work in higher Education for about 6 years and would like to break into Tech/fintech. I have an MBA and all the relevant experience (KPIs, modeling, ad box analysis etc…)

like

Anyone know of a good building for a 1bed/1bath. Need to have parking & a/c. Nice to haves is in-unit laundry, any include utilities, any amenities. Trying to keep it on the cheaper end with a max rent of 1,500, but given our line of work I can bump that up if the place is nice enough to justify the cost. Thanks in advance!

like

Selling a peloton cause I’m moving out of town in a couple weeks, ~4 months old, hardly used and in great condition, $1000 or best offer

like

Is there any mandatory working hours constraint in sg? Like in CTS we have to be logging hours for atleast 9 hours?

Taking the NY bar for the first time. Is it fine to take it from the work laptop because personal laptop seems to be giving up in life! Please guide any pros or cons. Thanks !

like

Just got an offer for a Cyber manager role in Deloitte based out of Toronto. Transferring from US as M2. HR setup time to talk salary expectations. Any feedback on salary range for cyber Ms in Toronto?

like

I feel like all of my friends who work in tech are very open about their starting salaries and the increases each year. I am going to work in public accounting and I feel like when I look up how much I will make after being promoted or early promoted it’s very cryptic. Can anyone tell me the standard salary % increase in PA after your first, second, third promotion?

like

Hi everyone,

I am looking for a job switch in the Project management domain.

Please refer to the attachment of my resume.

Any lead, referral and mentorship would mean a lot. I am a quick learner and task driven

Post Photo
like

Anyone else’s boss make them work until 630 on a Friday every single week? Please save me.

like

I'm looking for a comms planner for a mid-size agency in San Diego. 5-7 years overall experience with at least 1 full year spent exclusively on comms. DM me if you're interested, I'd consider more experienced as well.

like

Anyone here working for Goldman Sachs in its Investment Banking Division? Hit up please!!

like

Hi Fishes
I have recently joined bank of america, india branch, it's not been 15 days actually. And they are asking all the employees who are working from home to come to office. Which is 18 april. Can we as a employee ask the company to continue with the work from home model.

likefunny

EY GDS Pune hiring ?

like

No truer words were ever spoken. Can you name another great combo?

Post Photo
likefunny

Additional Posts in Excel Genius

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Anyone know what these badges are?

Post Photo
likefunny

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

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

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

Still don't have xlookup. #fomo

like

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?

likesmart

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

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.

likefunny

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

like

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

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

like

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

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 🙏

like

Everyone: Excel is a smart app
Excel:

Post Photo
likefunny

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