{ "media_type": "text", "post_content": "I am looking for a way to create a lookup in excel where I can type a value into a \"search\" cell, and excel will spit out every instance in a range where that search term occurs, as well as a corresponding value from a seperate cell.\n\nExample of what I envision attached. Data table on the right, search and results on the left.\n\nBonus points if it can be done with multiple columns of phrases.", "post_id": "60f86c6650c041002f12431d", "reply_count": 12, "vote_count": 8, "bowl_id": "5a56f68d15f6ef0013aad256", "bowl_name": "Excel Genius" }

I am looking for a way to create a lookup in excel where I can type a value into a "search" cell, and excel will spit out every instance in a range where that search term occurs, as well as a corresponding value from a seperate cell. Example of what I envision attached. Data table on the right, search and results on the left. Bonus points if it can be done with multiple columns of phrases.

Post Photo
likehelpful
Posting as :
works at
You are currently posting as works at

FILTER function

like

Building on this one - this is one of my favorite power tricks. https://exceljet.net/formula/cell-contains-which-things . It searches cells for any value within an array and only spits out the ones that match.

like

May be simpler just to filter the table by the appropriate column with a “contains” text filter.

like

Are you planning to search from the same column every time?

Yes.

Related Posts

Just got a targeted offer in the mail for delta gold card with 75K bonus miles, $95 fee waived for first year. Yes? No? (Have CSR, AMEX SPG, travel pretty exclusively with delta)

like

28/M solo trip ideas during Thanksgiving please ... Gotta use those spg and Marriott points ;)

Now that tips + gov fees are baked into Uber/Lyft/Food delivery apps, I’ve become much healthier and learned to cook this year! Bless all of you still in consulting who get more points cause of this though.

like

We are closer to the end of this initial selling than the beginning. All this technical selling on a 15 minute chart simply brings us back to a 4 Hour Halfway Back long of May 20 to Highs. And, we find support right in the middle of this HWB long. I think we can go a little lower to break the long in a dip below the 61.8% red line. Alternatively, we can hold here and rally. Either way, tomorrow or next week, we are due to rally 300 Nasdaq points. Take profits and be smart.

Post Photo
like

Wasn’t planning on jumping, but got a call for job in Silicon Valley with opening number $195/200 base, 30% bonus, “lucrative RSU grant.” I’m 1+6 post grad, thoughts on this being high or normal?

like

What are the packages like at PwC if you are laid off. Is it 2 weeks per year? Negotiable? If you are getting laid off in the next few weeks do you get your bonus?

like

Does anyone have 120K bonvoy points they’re willing to sell? How much?

like

Hard money loan for a buy, rehab rent project: 168k principal, 8% interest, 2.9% loan cost (4.8k) and 4 points (6.7k) The upfront cost seems a bit excessive to me or is this normal today?

like

Daiting in the age of corona Bonus points if you know the show

Post Photo
likefunnyhelpful

A bit past the halfway points. How’s everyone airline status looking? 50k MQM for me. 0 carryover from last year. Would love to hit 75k for Platinum by EOY

like

Plane DEN-ORD took off, 40 mins into the flight had to turn around and land back in DEN because of fuel problems/leakage. How many points/$$ in voucher should I ask for?

like

I know right now many people(especially in audit) are jumping ships from one PA firm to another! Please, please, make sure that you get the highest possible base salary and sign on bonus!!! Those firms don’t want you, they need you!!! So make sure to squeeze as much money as possible and remember that they won’t think twice to squeeze you as well as soon as you join them.

likehelpful

Getting married & booking hotel block at a sheraton...do thy still do the thing where you get points for hosting an event? Marriott did, not sure how it works now...

like

Spg or Hilton honors? Currently spg plat but wanted to know if anyone had better experiences with Hilton (service, upgrades, points accumulation mainly)

like

10 points if you can spot which one’s the new Apple ad.

Post Photo
likefunny

Do big4 have signing bonus when moving from US to Europe (moving within the same big4) ? Tax and Audit

like

I received an offer from PWC - consulting services as follows. Is this competitive or should I negotiate it? - Manager level - DC based (non-government work) - Commercial Transformation $175K base, $15K signing bonus, up to 25% performance bonus Thoughts?

like

Additional Posts

As an incoming healthcare Provider Operation EA at PwC what can I expect? Background is in operation manager but what are some skill sets I should brush up on? Excel,power bi, ppt, tableau and what else? I have 3 weeks before I start and I want to be ready. Also for traveling, does this position require international travel as well or domestic travel throughout the states. Just out of curiosity. Thanks again you guys!

like

Can someone confirm: flying United Economy (K) from LAX-IAD-LHR, the LAX-IAD route is 20 PlusPoints to upgrade to biz, IAD-LHR routes are 80 plus points.

What companies use product principles in their development process. LinkedIn is big on this - every PRD lists out “product principles” at the top and they’re heavily discussed. I think it’s an odd part of the product culture at LinkedIn and an curious what other companies do this.

like

Is a mental health sabbatical a thing ?

like

Anyone wanna grab my Marriott points? 100k points up for sale. Flat 600$ and it's yours.

like

I’ve been laid off and, as I embark on my job search, I’d like to keep my marketing skills sharp. Any recommendations on must read books, or resources?

like

Anybody need an Accenture referral? If so message me your contact info.

like
like

What will you do with the “investment” part your bonus this year? Where will you put it and over what timeline? Normally I DCA over 2 months, but fear that I’m buying on top of a cliff this year

like

What is your bonus amount at your firm and which role are you?

funny

South Indian restaurant recommendations in San Francisco?

like

Alt travel: flights to London from client are cheaper than back home. 3 days in Europe? Heard conflicting statements if intl flights are OK to expense for alt travel.

like

In case H1B gets denied (I hope that doesn’t happen), what countries have you considered moving to besides Canada. Indian national and pending transfer to MBB if that helps.

like

Why exactly is the lateral market so hot? More deals going on? People leaving big law completely? More people taking parental leave? A mix of these things?

like

Any insights into compensation details for a “Security Program Manager - Tech” at Uber with 7 YOE? TIA!

like

How much is a senior con 6.5 year work ex (2 pre mba, 4.5 post mba) tier 1 mba expected to earn at Deloitte india strategy consulting?

like

👋🏽 I have an LEK consulting interview...any tips on what to expect on the written case? Thanks for your help!

like

That feeling when you get an exit row seat and find out your neighboring seat is empty 🎉🍻

like

Quit my cushy job a few months ago because I was totally burnt out and mental health was shot. Thinking about quitting this industry all together - anyone else go through similar? Any advice? Thanks!

like

Where do you work and what are your company’s plan to return to office? Is it fully remote, hybrid or mandatory in office? Curious to know if other workplaces are also enforcing vaccination as a condition of employment.

like

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

Get realtime notifications and see
what's happening in your industry
from the palm of your hand.

For account settings, visit Fishbowl on Desktop Browser or

General

Legal