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

More Posts

I work in analytics but love the salesforce ecosystem. Any tips on how to merge the two? I have a couple of implementation projects under my belt as a PM from my old job, but I don't think that's enough.

like

Hi ladies. I wanna start looking into grad school programs (mainly analytical/MS types but MBA is also on the table) but there’s SO much info out there that I’m a little overwhelmed. Any good starting resources/sites you recommend to ease the process?

likehelpful

Larsen & Toubro Infotech Hi Fishes, Optum or Larsen & Toubro Infotech !! Which one to choose ? Both are offering same package. Skill Set :MSBI YOE:9+

likesmart

Hello Everyone,

I've 2 years experience in Mainframe COBOL in Capgemini and I would like to apply for the same in outside as well.. can someone please refer me?

like

IBD Nordics members?

like

Hi.. I am happy to join here. Seems to be an amazing platform.

like

Are there any tests you can get done to understand your fertility? I have PCOS and cannot start trying until next year or two. I would like to know if there will be any issues with conceiving due to my PCOS. I’m 29 right now. I asked my OBGYN and she said that unless I start trying, there’s not much in terms of testing she can do and that she wouldn’t recommend it. Has anyone ever gotten any fertility tests done to understand if you’ll have future issues?

like

Hello! Any CST/CSFAs on here? I'm curious about your salary and location! My small community hospital was recently bought by a very large hospital system. They gave large raises to 95% of our employees across all specialties (some called what they got "life changing") but our group was overlooked or disregarded with no explanation! Now we are losing employees (4 have put in notices in the last 3 weeks and pretty much everyone is looking). Any suggestions on getting someone to reassess our wage?

like

Can anyone provide me insights into the EY GPS Finance - Budget and Cost Optimization practice?

Currently in Deloitte GPS Risk and Financial Advisory - Accounting and Internal Controls and thinking about making the switch

like
likeuplifting

Firm restrictions notwithstanding, what are some side hustles/additional sources of income one can generate while being on H1B or L1A?

like

I got into marketing because I thought it would be an opportunity to make good money in a field where I could still exercise my creativity, but I’ve found it to be extremely stifling and bogged down by bureaucracy. Does it ever get better?

like
like

I started taking Adderal, 2.5 g which is not really a lot. It didn’t really help with my focus, instead I felt restless and somehow nervous and really thirsty. And it made me clench my teeth. I do grind my teeth during nighttime but never experienced this in the daytime. Does it take time to get used to it?

like

Is anyone selling any luxury bags they don’t use anymore? In great condition.

like

I have a case/ excel interview with a revenue Cycle team soon. What is the best way to prepare for it?

like

The bills this week

Post Photo
likefunny

PWC AC Kolkata UK team is the worst team.

They put a status call at 10 in the morning and expect to work throughout the day till 9PM with all the calls at night

If someone logs off at 8ish also. It is considered as early off. One the worst work life balance ever in UK supporting organisation.

There is no concept of 9 hours work schedule. I want to name few people but doing it

funny

A real gem from Henry Ford: "stopping advertising to save money is like stopping your watch to save time."

likeuplifting

I received mindtree offer letter with 60 days. Since my current notice period is 90 days, HR informed that they can extend the dates later and reissue the updated letter.
Is it the process of mindtree and is it okay to resign with this initial 60 days offer letter?

like

Additional Posts in Excel Genius

I have a workbook with a couple of custom lists that we use every month in my department. I'm handing off this responsibility to someone else who will be using their own laptop to do it. Will the custom lists pull over to their version, or do we have to set them up in their version of excel on their laptop?

like

Is it possible to conditionally format text boxes?

Hey everyone. So in my pivot I have two categories that are in rows and several calculated fields. I am trying to get data behind a specific value in a calculated field. Whenever I double click the specific value, it is giving me rows for the entire category and not for that value. I think there is no way to achieve this; but if there is, I would really appreciate the help. Thanks!

like

What task would you expect excel of being able to do but you have never been able to make excel do it.

like

I’m doing a simple IF lookup, if A = B, if true Yes, if false No. it works correctly for 90% of the table but there are a few it shows as false. When I did a simple does Cell A = Cell B to see if any issue, it shows as true. Why is my lookup acting funky?

like

Best pdf to excel converter?

like

I have two columns in Excel, let’s call them A and B. I want to see if the numerical IDs in column A are also captured in column B or not. What formula would help me get this?

like

Is there a function key to add an IFERROR statement quickly on a formula the same way you can add an absolute constraint with F4??

like

Does anyone have any suggestions of where I can learn how to create Mode queries efficiently? Also possibly a refresher course on Excel/ Google Sheets.

like

Best way to learn power query & power pivot?

like

Can someone please explain a vlook up part with the columns being a certain number of rows from whatever?

like

Hello Everyone,
I would like to create a schedule for all of my clients. Let’s say I have platinum, gold clients etc. What would be the best way for me to schedule a call for them based on their profile of gold or platinum? For example, I would start scheduling a call every month for my top clients, then a call every quarter for other categories… I need to track the data, and make sure employees are calling them… something that would alert my employees to call such clients. Thanks!

like

I need some help... I am creating a spreadsheet (Google) that will help our Team Leads better understand where to coach their reps. Reason, a lot of different come from a lot of different places. I want to convert the sheet to a more descriptive PDF to summarize where to coach. In the screenshot there’s a table with KPIs. In column “2” where the values equal “0”, I want to extract the names of the people (first column, blacked out names) and display them in blank space above. Ideas?

Post Photo
like

Does anyone have experience setting up automated queries on Excel for Mac? I am trying to automate a paid search pacing document but am running into an issue with the Excel Power Query not being able to log in to Search Ads 360.

like

Dynamic Range Question- I have monthly P&L data. From this data, I want to create a PL report that uses the start date and end date input from user and calculates the P&L for that period.

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

My excel skills during quarantine

Post Photo
likefunny

Can anyone recommend free or paid excel resources that are more general in nature? I need to up my skills but not in one specific area. Thanks!

likehelpful

Does anyone know a shortcut for unhiding rows/columns. I.e. the inverse of Ctrl+9 and Ctrl+0?

like

Hi, I’m looking to take a weighted average that ignores rows that have text. What’s the best way to do this? Thanks!

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