{ "media_type": "text", "post_content": "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", "post_id": "606b7a8c63c9b90021365830", "reply_count": 4, "vote_count": 1, "bowl_id": "5a56f68d15f6ef0013aad256", "bowl_name": "Excel Genius", "feed_type": "bowl" }

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

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

Rather than using PQ, if the lookup values are in one cell separated by commas, wondering if you could just do text to columns using the comma as the delimiter and once all the values are in different columns of one row, then copy those values and paste special transposed going downward in a column? Then do the vlookup off there? This would at least solve the first step? But not 100% sure without seeing the data

like

I would agree that text to column and Vlookup would be a way to go. I would like to see the data myself

Idk if I would use PQ for this (specially because Idk PQ), but I’m pretty sure it can be done in excel alone, but would need to take a look at the data first! Does it have any logic/repetition in these values?!

Ex. The values will always be 3 letters, or something like that?

I think power Query is not a bad idea if you have repeated data sets with this particular type of issue. We just need to apply some steps and formulas in the query editor to make this happen

Additional Posts in Excel Genius

How much times does Lawyers need to file i140 petition once the PERM is approved.
Its been more than 2 weeks since PERM approval but lawyers are still drafting and assessing my case, I have opted for premium processing (self sponsor).

like

Whats your negotiation strategy when the recruiter offers you 20% base less than what you expected? Overall 30% less in TC.

like

Share my work here. Need likes to open my DM.

PS: I am currently looking for a SEO/SEM role (remote in Canada). If anyone can kindly offer a referral, that will be much appreciated.

4+ years of experience in digital marketing. Interested in e-commerce and customer marketing.

Post Photo
likeuplifting

Is anyone attended Amazon QAE interview ?

like

Hi all,
Requesting referrals for a legal role at Deloitte USI. Please connect over DM or comment to connect further. Thanks!

like

Hi all, moving from US to China due to visa complications - anyone have recommendations on company to use to ship boxes? Cheap but reliable would be good - not a ton of boxes just cloth and things thx

like

Favorite Webex/Zoom fail?

like

Hey all! Been doing a lot of unofficial strategy work in my official CM role and am now looking to step my game up and be a social/creative strategist. Have you done this transition+how?

like

Hi all. I’m a ux designer at a small company and need to recruit a few people for usability testing. Our target demographic is people over the age of 35 who’ve been in leaderships positions. If you’re interested I’ll send the link- the test will take about 15-30 minutes and pays 20$. No human interaction required.

Guys,

Curious to know what's the salary range for Junior Engagement Manager in Workday consulting for overall 9 year of experience in India at big 4?

Hi Fishes,

I have 2 offers,
1. UBS mumbai as X amount, bonus as discretionary. Probation: 3mnth
2. @BP Pune as same X amount, bonus as 18% . Probation: 6month

Which one is better ,and why?

I am graduating MBA in 2 weeks and have two offers on hand, one from Amazon in their Finance Leadership Development Program and another from Marcum LLP for Transaction Advisory Manager. I did summer internship at Amazon but worked at Deloitte in TAS befor MBA. what are your thoughts?? Which is a better one? Pay is pretty much same in both cases although Marcum has higher base pay

like

Hi everyone!

Currently looking to rent a bot off of the GetMyBoat app and was wondering how strict the 12 person rule is when renting. Can anyone let me know how strict that rule is or advice in general when getting a boat?

Thanks again!

like

Has anyone passed the 2021 payables exam?

like

Hi all! How long is appropriate to wait until you assume you didn’t get the role? I did my final interview a week ago and prior to that, the company was really amazing with booking interviews. Should I wait another week? I emailed them asking for an update or if they needed any other information but didn’t get a response…

likehelpful

How much can we get for QAE 2 role in Amazon
Experience- 6.5 years
Technical skills - Selenium, Java, Rest assured api automation, Postman, Jenkins basic knowledge and Functional testing
Location-Chennai
CCTc -13. 5 lakhs fixed

like

Anyone here use Moat’s ad search? I know there’s a similar search site focused on newsletters. But for the life of me I can’t remember. Anyone know what I’m talking about?

like

Hi folks,

I wanted to know what I can do to reduce my Training Agreement Amount. Its been set at 3 Lakhs but I want to leave the company. Ive already served 1 year out of 2. I’ve also delivered 2x value to company and also won awards. I believe I’ve done enough to balance that 3 lakhs.

I want to leave this company to pursue higher education.

Funny thing is, I barely used any technology they taught us during training in actual projects.

like

Associate Media Director in LA?

Additional Posts (overall)

Can someone provide the most efficient way to send multiple emails in Outlook which contain excel spreadsheets into a single pdf file and not an outlook file?

like

I need to change a column of text. The text in the column currently is a ranking we used for sales data ex. Tier 1, Tier 2, etc. and I need to change it to Small medium or large. There are 8 tiers that are condensing down 4, so I was hoping to use OR or something so I wouldn't have to write 8 parts in the function since there are repeats (Both tier 1 and 2 should put out "large). However, thats not working. Any help?

like

PowerBI/Excel- have payroll data for full year and would like to calculate average pay per employee and extract records +\- 10% of average for each employee. Any ideas on how to go about this?

like

I wanted to check if there are any free database server's available online (works even if it's of a small capcity like 5MB) wanted to polish my SQL skills by fetching the database.

All ears for any other useful ways I can try practising.

PS: searched for a SQL bowl couldn't find one😅

like

I have a spreadsheet with many lines of data. The first 6 columns do not change from month to month, but the next 5 columns change monthly. Our current process is to copy/paste the new (continued)

This is by far the best thing to ever exist... no more finding ways to affix a weight to the enter button to keep pressing yes... YES TO ALL!!!!! The little things that keep me going :)

Post Photo
likefunnyupliftinghelpful

Hi what are your favorite shortcuts in Excel? I'm not yet a genius and could use the advice!!

likesmart

I’m a string starting from the left, I want to identify the first numeric digit and return digit and everything to the right. Tips?

like

Hello Everyone,
How do I capitalize the three letters in parentheses, as per below picture?
I appreciate your help!

Post Photo
like

I have a data set of ~500 restaurants. I want to sum the total order value for each restaurant. What formula can I write to only add the order value (red column) for each restaurant (orange column eg 1,2,3,4). I want to lay out this data on a graph to see which restaurants generate the most revenue. Any tips?

like

What color is ‘excel green’?

like

Any advice on tools to use outside of excel to break into more data analytics roles? Have you found python to be useful? Best way to learn and practice and to get better? What data sets you use?

like

Are the betas pulled straight from CapIQ levered or unlevered?

Hey everyone I have a problem and hoping someone has a solution.
I have a spreadsheet I enter data into every week, print it, and then next week replace the data on that sheet with new info.
What I want to do is find a way to save the info from the first sheet into another sheet so I know all the inputs I have ever entered (I should have led with, this is product I am donating to a charity each week, and I want to be able to track long term everything I have given.)
Anyone know how to do this?

like

I have an index/match function that works and looks up one specific value. How could I add to it to be able to do a pull and fill to get the other values from the table im looking at that also match this one criteria?

like

Hey! I get confused on understanding the order of operations to solving if functions. Anyone have tips and tricks? I have the solution to the right but don’t know how to get there. Thanks!

Post Photo
like

I recall using a macro that identifies duplicate GL accounts and condensed them into one ( including associated $ amounts) .. have a trial balance with multiple instances of same gl accounts but under different departments..want to get rid of department info and condense multiple ( but same) gl acts before importing into software..any suggestions? Thanks in advance

like

What I learned this week: Sometimes the "Run-Time Error 1004 method 'copy' object '_worksheet' failed" message has nothing to do with the VBA code. Rather the worksheets being copied are incompatible.

likehelpful

Stupid question but new to this. How can I easily compare/contrast the contents of 3 lists? I have 3 lists that ideally should contain the same things (all identified by the ID numbers) but some are missing and some are unique to each list. Basically, I want to see what’s in list A, B, and C to creat a comprehensive master list. I was thinking something with index,match, and if…thank you!

like

I have a column with 8 possible values and for 3 of them, I want to tag every such row with a word. Help what formula should I use? I basically need to scour every row for those 3 and segregate those from the others.

likehelpful

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
Download Fishbowl to see what others are saying
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

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

New to Fishbowl?

image with Fishbowl logo and arms reaching out for a handshake

Already have an account? Log in

By continuing you agree to Terms of Use and Privacy Policy.
Messaging rates may apply

For account settings, visit Fishbowl on Desktop Browser or

General

Legal