match 2 criteria

Hi Everyone, I'm working on this unique case. I've a table (raw data) in which I have Column 4 columns named Country, Supplier, Parts, and Net Price. Country Supplier Parts Net Price Germany Intel Part 1 2.30 Germany Intel Part 2 2.34 Germany Spirax Part 1.A 2.38 Germany Romoss Part...

I have shipment names with the days of the week they ship abbreviated inside them. For instance Shipment1_M_WThF. This shipment goes out on Mondays, Wednesdays, Thursdays, and Fridays. I also have Shipment2_Fr-Su, which goes out on Friday, Saturday, and Sunday. I also have a shipment tracker...

worksheet table y x 0.1 0 (0.1) (0.2) (2.3) (0.2769) (0.1216) (2.4) (2.5) 0.0167 (0.0624) (2.6) (2.7) 0.0698 (0.1279) 0.0923 (2.8) 0.0692 (0.1111) predictions formula used...

I want to know the row number matching two values in two columns. SHEET 1 ↓↓↓↓ COLUMN 1 COLUMN 2 COLUMN 3 A 1 B 2 B 1 SHEET 2 ↓↓↓↓ COLUMN 1 COLUMN 2 COLUMN 3 A 1 I want the row number HERE from sheet1 B 1 Here result should be 3 Do you know any formula which I can...

This, I thought would be easy... I'm still very much a novice but I've been learning and I can do it with array formulas so I thought, VBA shouldn't be a problem... one whole Saturday later. I have a very large and growing range of data, Sheet("Tally"), the source And another...

Hi, so I've been looking around for a kind of self-project that I have in mind. I got a list of different descriptions with variable components, basically my idea is: if I have a certain amount of this component and a certain amount of this other component, display all the matches based on the...

I`m trying to work out a formula, on how to get the MAX amount, for any 30 day consumption period, for a certain item, when all the criteria are in one data table. I have created a formula in column D, that Sums up the amount used in the last 30 days. The Pivot table in columns A & B...

Hello, I have two columns of dates as shown in the below table: <tbody> 5/1/2016 01:00 5/1/2016 01:00 yes 5/1/2016 02:00 5/1/2016 04:00 yes 5/1/2016 02:00 6/1/2016 05:00 yes 5/1/2016 03:00 7/2/2016 10:00 no 5/1/2016 04:00 8/2/2016 05:00 yes 5/1/2016 05:00 9/3/2016 05:00 no...

Page 1 C372)Ag Non Real Estate C374)City. D375)#loan E375)Balance C375)Ag loan. C376)Ag line Page 2 A1)Ag Non Real Estate. B1)City. C1)Product. D1)Ag loan. E1)4. F1)$480 Ag Non Real Estate. City. Ag line. 3. $350 (same layout as first record) How do I bring back the count and dollars to page...

I have two worksheets. One has a project Code with corresponding reference codes in the cell to its right. Altogether there are several hundred project codes and about five corresponding reference codes which match. (More than one project code can match a single corresponding reference code but...

Table 1: <tbody> Date Code Price Ideal Price 01/01/2017 7 ? 0 02/02/2017 4 ? 0 03/03/2017 7 ? 80 </tbody> Table 2: <tbody> Sale Date Code Price 01/10/2017 4 $70 03/02/2017 4 $65 03/06/2017 7 $80 </tbody> I want to populate table 1 prices based on a combination of...

Hi, I'm breaking my head on this one. The data set contains: on Worksheet 1, a table with thousands of projects: column A: company name (not unique for each project) column B: start date of project column C: end date of project ...with every row being a single project on Worksheet 2, a...

Dear all, Currently im familiarizing myself more and more with excel. However I've run into a rather annoying problem. I have made a table which is rougly 60 vertical cells and 70 horizontal cells. Out of a prior calculation 2 keys are found. One horizontal value , one vertical value. Now I'd...

Good afternoon, I have two main sheets that are outputs of a process. Sheet 1 has a list of critical roles and the behavioural competencies for that role and each role is rated depending on whether that competency is Critical to the Role, Highly Desirable, or not necessary. Sheet 2 has...

Hi there, I am usually able to find the answer to my issue within the forum, however this time I am not sure if I have seen it or not...haha Here is what I am trying to do. I would like to summarize on a separate sheet, sales based on month and item. DataSheet <tbody> A B C 1 Date Item...

Requesting formula assistance for following: If 2 cells in Column D Match & Column C Match & Column B 'Date Time' is < 10 Minutes Result is corresponding value from Column A. To answer the question "What orders were done by same employee from the same Customer during the same Order call?"...

I want to match the (Sheet1) clent /group to the (LookupTable)name /group and return the corresponding retention. Formula i am using in Sheet1 cell-Retention Policy but is returning the wrong retention because I have multiple instances of the client/ name...

I am trying to automate a process so that I can import a budget from QuickBooks and do less manual work in the future. The workbook would have 2 tabs, a "permanent" tab that is formatted the way I like, and most of the cells would be INDEX+MATCH lookups to the other tab; and the "import" tab...

Hi, I'm stuck with a Match INdex formula. In the example above, how can I get the fruit that matches with the date to appear in column G? Is Match Index the right formula or is there something I could be using? Cheers!

Hi, I need to look at a range of values that consist of customer name, item # & colors available. I need to know if a specific combination exists in the list. I am using a countifs statement to accomplish this, but I can't figure out the color part. I can't search a range of values to see if a...