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

I'm in the market for monitors for my home office. Does anyone have any advice?

like

If I get fired while on OPT without getting my H1-B stamped, is it useless or can it be used in future for some other job?

like

I have a question for associates, what would help you the most in your job right now? It could be technical, communication, training, mental health. What are you biggest problems and struggles?

like

Should I break up with my girlfriend? We have been dating for close to 2 years and there are some things that have irked me (her lack of care around finances, talks about her exes, super insecure about her looks (complained to me when she was drunk last Friday how no guys bought her drinks, I wasn’t there), has a terrible relationship with her mom and dad and gets upset when I go out for the weekend to hangout with my mom (father died horribly last year and she has been alone). To be continued.

likefunny

My other half (currently a Sr. Mgr in the data analytics consulting industry in UK) wants to work in Singapore - is there some sort of parents' visa so that his parents can tag along to stay in SG for the long term? Worried about them as he is the only child. His parents have the money to buy a condo if it helps with their long term stay situation.

like

Can anyone tell me if Marcum drug tests experienced hires?

like

First time poster here!

After spending 4 years as a mid-level ops manager, I tried to break into HR through talent acquisition. Now after 6 years in TA, I've had a hard time getting out of it. My goal was always to get into a more broad HRBP position, but I've since worked for smaller orgs without a solid HR career path. When I ask about my career goals, they keep telling me, "Soon!" Or "Maybe in 6 months!"

I'm testing SPHR in June. Any advice for securing the type of role I'm aiming for?

like

Hi, I am looking for a referral at Barclays , I have the job ID with me. Can someone please help me? Thanks in advance

like

Dear Microsoft Fishes,

How is work pressure in Level 58 support engineer roles.

Please put some light on the culture and work life balance.

Any openings at Microsoft for a Project Management profile?

Hi guys. What's the status of Microsoft employees in India currently. Any firings going on due to market conditions? Microsoft

like

Who else got an offer from mindtree can please share YOE, designation and CTC offered so that It can be helpful for others.

like

At Mindtree, I had only 1 technical round and submitted google form then I had ctc discussion with HR and she said that she is sending for approval.
How long it takes to get ctc approved and also will there be managerial round as well?

like
like

Look for the fishbowl banner for donor choose. Enter your link so you get funding.

Hi all, any CDD openings with your firm?

like

PE ops companies in Singapore?

like

On the news, there was a report that "stress" causes negative health effects. Um. OK. Don't people feel "stress" just by being alive? Like, what would be the control group that you could measure the results against? I don't know why, but it always makes me wonder

like

How many times were you told you were being "unrealistic"?

like

Looking for single females 20-25 to do Christmas dates with.

Including max Brenners, seeing the Rockefeller tree, ice skating at Bryant part, and the winter markets

likefunny

Additional Posts in Excel Genius

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
like

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

like

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

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!

helpful

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

likehelpful

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

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

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 🙏

like

Would anyone be willing to teach me vlookup?

like

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

like

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

like

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!

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
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

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

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.

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