Help! I need help with creating a formula that will help me get the requirement of a value falls within multiple parameters. So, what formula should I use in the red cells to return the answer I'm expecting from the right cells?

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

I figured it out. I used vlookup with true as my type of match. Please let me know what you would've used

like

Vlookup with a fuzzy match sounds like it works

Alt + W + V + G

funny

Probably some kinda messy IF function?

I would go with multi parameter xlookup

Related Posts

I just wanted to say that my Art Director partner is amazing and I’m the luckiest writer I know.

likeuplifting

My products:
F / 23 / Combo skin

Wash: La Roche-Posay Effaclar Medicated Gel Facial Cleanser
Tone: Paula's Choice Skin Perfecting 2% BHA
Moisturizer: Eucerin Skin Calming Cream
Eye cream: The INKEY List Caffeine Eye Cream
SPF: Eucerin Daily Protection Face Lotion - Broad Spectrum SPF 30

Acne treatments: Differin 0.1% Adapalene, Gel, Mario Badescu Drying Lotion

like

DTC - fad or future? I interviewed the CEO of Lively the other day (undies dtc) and she suggested it’s just a catch all term that will age out in a few years.

McKinsey & Company Any advice to help prepare for data science analyst role at top consulting firms (McKinsey & Company EY Boston Consulting Group etc)? Any materials, open source platform recommended to take on freelance data science project? When should I start actively looking and applying? I am a new grad who is working in tech as a marketing analyst I’m looking to pivot to marketing& sales data science consulting next year. Would like someone with similar backgrounds offer some practical tips.

like

Bro Its been 3 years I j still don't have a 5star Island I need help😭

like

Alright everyone, I’m on my exit path from Big D and looking for someone to take the bowl leader spot. Pls DM me if you are interested. Thank you

like

Anyone willing to refer for KPMG Atlanta office, financial solutions practice? I'm relocating to the Atlanta area. TIA

like

Hi guys, i am new to automation.
Is it possible to automate a software (not browser automation)?

Eg. Can be suppose ms word we can go to any menu item and sub menu item etc.

like
like

How many of you relate 😁

Post Photo

Hi
Anybody from hsbc provide me a referral for sr.analyst position in analytics

Yoe 2.4
Tech: python,SQL,pbi

like

Hi fishers,
Could somebody tell me how much time does it take to generate offer letter after HR salary discussion in Ericsson?

Hello travel buddies! I have recently started travel hacking and currently have the Chase Sapphire Preferred, Capital One Venture, Marriott Bonvoy Boundless, and Citi Premier Cards. Please comment if you would like a referral link for any of these!

like

Have you had a project funded? What did you get? Share!

Anyone seeing big declines in FB/Insta performance? Across several clients we’re seeing CTRs or other ad engagements dip starting in July.

like

Has anyone here ever been fired for being rude to a customer?

like

Looking for referrals for PwC Australia ..

I need you help to work in you country i want know you country and your culture

like

Will TCS blacklist people who accept the offer letter but don’t join TCS, for any other reason

like

Additional Posts in Excel Genius

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

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.

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

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)

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

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

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

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

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

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

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

likehelpful

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

like

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?

like

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

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

How do you fix microsoft excel cannot paste data error?

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

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

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

like

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