I have two sperate sheets, i need to extract volume and cost from the second to the first sheet, but they have to match the criteria like origin/destination, packaging type, what can i use to do so?

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

(i) Index match with multiple criteria - e.g.: =INDEX(range,MATCH(1,(criteira1_range=criteria1)*(criteria2_range=criteria2)...,0))

(ii) Create a key (concatenate every match criteria) and use it as a criteria for any reference formula (Index match, vlookup, xlookup, filter, etc)

(iii) Use any non-trivial reference formula like =OFFSET(), =UNIQUE(FILTER()), etc

like

Also just to clarify, you don't need to name anything. You can use the "A1:A20" reference

Related Posts

If a recruiter reaches out, you have a great initial convo then they say they’ll follow-up shortly with next steps and don’t (after 7 biz days). Is it worth following-up? My sense is if they were interested they would be pushing the process forward?

like

Marketing Career: When should I move to the director level? I have 4-5 years of Growth Marketing experience and my salary is stuck at $100k. I want to make $200k within the next year - what should I do?

like

Hi Fishes,

I have joined
Nagarro as Node JS Developer. If possible please suggest tips for finding good Project here.

Thanks

likesmart

Hey folks,

I am Milan Raja from Jamshedpur Jharkhand. Completed my BCA from Garden City University with 8.5 CGPA and currently working in Cymmetri as a java developer intern. And holding a total of 8 months of Internship experience. 

If you have any referral or job openings in java developer or backend developer please do let me know so that I can grab the opportunity. 

Regards

Milan Raja

What is wrong with Tech Mahindra HR.. everytime i call them they say same answer pending for approval...not sure what approval they are looking for past 15 days...if they are planning to put my position on hold they should mail me or when i cal them they should inform..but nothing is happening..do i need to wait or better search for other opportunities? Please suggest...@ Tech Mahindra

like

I am having 5.5 years of experience. I am looking for a job change. My skills are AWS, Azure, DevOps, ShellScripting, ARM, Powershell, Kubernetes, and Docker.

Can someone help me with a referal.

Thanks :)

like

My husband yells at me in front of my 2 years old, even when he is scared. He needs to express his anger out before he can shut down. I am planning to leave him but I am hesitant because I am afraid this would negatively impact my son more, not having a father figure around much.... not the first time, my husband promises multiple time that at least he would control his anger in front of kid but never Lee up the promise...sometimes he would even throw stuff (not at me and my child)...

like
likefunny

Hey recruiters why don't you look at portfolio's before blowing smoke up my ass? Truly I want to know.

like

Electrical & mechanical engineering interns needed for our SF office. DM to discuss a potential referral 🚀

like

Hi IBMer . Can some one share amex related helpdesk number Of IBM India

like

Need some Valentine's Day advice: I need a valentine 😢

like

Do work clothes fit me?
Are these outfits still in style?
Do I have to get my hair done?
What is a work shoe?

likefunny

How do we get invited to speak at TED (not TEDx)? I saw a few BCG partners+ speaking at TED but not really McKinsey partners

likeupliftingfunny

Hi Fishes,
I joined my current organization 3 months back.
Didnt allocated any project yet.

Now i am looking for a change:
Can someone refer me:
YOE :8.9
Location: Bangalore
Notice period: 30days
skills: java, spring boot, hibernate.

Thanks in advance.

Need help for an older woman to find her job in Philadelphia. She is in her 60’s and can be a good admin assistant without computer knowledge. Sorry but if you know anything please advise.

Any IPS advisory folks here ?

Anyone a MH housing case manager? Let's chat.

like

Sometimes (not always) I feel like hiring managers get intimidated by me during interviews. I'm quite driven and have a big personality.

Genuinely curious, hiring managers - you ever not consider someone for fear they might outshine you?

funnylike

Additional Posts in Excel Genius

Hey, tips for where to look for good excel cheat sheets online? :)

Last cell question. Some of my simple models are massive in file size because every tab has a last cell of ~XFD65. But I’m not using anything past ~U100. Continued.

like

Hey Geniuses! I apologize in advance if this question has been asked before, I'm new here and just trying to learn as much as i can. Does anyone know a great source to learn Macros for beginners. I would like to create one for work. I appreciate it

like

Our system is really lacking and we do a lot of work outside of it to track data. Currently I’m using Excel to track data from multiple resources, however, it’s so manual and prone to error. Any suggestions to keep the data clean when I have to pull info from multiple places? I’m constantly auditing and we won’t even look at getting a new system until next year :(

Best pdf to excel converter?

like

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

like

How do you all prepare for excel/financial modeling tests? Every firm is different, so I imagine there are multiple effective ways to get ready.

likehelpful

Hi team i have a bit of doubt.
I have an excel sheet where column A is the order numbers. I want to add comments in column G.
There are many repetitions in order numbers but they are all sorted in ascending so all the repetitions are below one another.

If i have a comment, how can i automatically paste that same comment in all the repetitions of that order numbers if i write it in the 1st instance.

Thanks in advance

like

Can you share the most useful formulae and built in automation features you have used with the latest version of excel?

like

At my old firms when I would be using excel and modeling using the font schemes (blue, green, black for hardcode, link, and formula) I could use the “control shift ;” to shift through the schemes. My new firm doesn’t do this. Does anyone know why the shortcut would be different and how I can add it back?

like

If you follow him on LinkedIn you probably already saw this! Lol 😆 but I totally resonate with the post... 🤣

Post Photo
funnylike

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

like

Has anyone encountered this error before? We can’t access a workpaper with 70% of the work done 😩😩

Post Photo
like

What are the most typical models you all build

likehelpful

Does anyone know how I can conditionally format a table with a sliding scale? I have a value that is supposed to fit in a range. I need the first possible range the number can fit in to be formatted. Thanks

likehelpful

Google Sheets vs Excel - pros? cons? differences?

likefunnysmarthelpful

Is there a way to consolidate non numerical data from multiple excel sheets into one master sheet?

like

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

I’ve toggled the “Show Formula” setting and it changes nothing. File format is xlsx, so that shouldn’t be the issue. Any ideas why these are showing the formula instead of the output?

Post Photo
like

How do I stop excel from changing the cell reference to a different column each time I refresh the data pull?
The spreadsheet is connected to an API data pull. Each time I refresh the data it changes the cell reference (SCD_0010) to a different cell e.g. (SCD_0127). How can I stop this?

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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