index-match

Hi there, I am trying to automate a meeting planner. I have meetings down the rows, employee participants and time of meetings along the columns and market with "x" in the cells. I would now like excel to automatically populate a new "calendar overview"-table with the times down the rows...

Greetings, Working on a pricing tool, where the part numbers can have multiple tiers and different number of tiers, based on volume. I've been struggling with trying to index/match the part number in column A (exact) and the volume in column C (approximate based on tier) but either end up with a...

Hi. Stumped on this for a while. I would like to find all the values of an item in a range like a sort of index-match, then find the trimmed mean of those values, and repeat this process for each of the other items in the range. Attached is a sample sheet showing what i would like. Would be...

Hello, I have 2 columns of data: State City Texas Dallas Texas (not set) Colorado Boulder Utah Salt Lake City I am trying to use a function in a new column to replace city records which equal "(not set)" and reference the respective cell's state to return the correct value. For the...

Hi, I need to convert several currencies across multiple rows into GBP by looking up a conversion table and then provide the sum in GBP. I haven't been able to come up with an elegant formula (an array type formula maybe) to keep it short and simple. for the SUM in GBP, I've got the...

Hello, Can you help me with this, I need to put in the result the max "320" https://docs.google.com/spreadsheets...it?usp=sharing

Hello all again. It's been a while. As usual, I have scoured, and cannot find an existing answer. If an answer exists, please redirect, otherwise, I need some help. Situation: I keep a growing database (excel) of samples, for multiple customers, that I have cataloged and shipped for my job...

I have this formula : INDEX(A2:A20,MATCH(1,(F10=C2:C20)*(F11=B2:B20),0) It returns the exact match. I need the formula to return the closest match if the there's no exact match this is my data : A2:A20 I need to find the PO that is closest to the date 19-03-17 , the result should be : P91180...

Hey all, I'm looking for a way to dynamically lookup markup rates from another worksheet, multiply them by the correct prices for matching products on the sales worksheet, and display it as a total markup amount beneath the subtotal. Some of the items, however, need to be excluded from the...

<colgroup><col width="85" style="width: 64pt;"><col width="73" style="width: 55pt;"><col width="83" style="width: 62pt;"><col width="73" span="9" style="width: 55pt;"><col width="220" style="width: 165pt;"></colgroup><tbody> I am using CHOOSE to select a formula based on a criteria...

Hello, does anybody know how to draw up an index-match formula with the possibility to search in another sheet, whereby using a dynamic entry for sheet? <tbody> sheet column row output 1 1 3 ?? 2 2 4 ?? 3 1 2 ?? </tbody> Kind regards, Niels

How do I pull only certain data from one section to another section? In my spreadsheet for example, I have something like this here: <tbody> A B C D E F G H 1 ORG FIRST LAST DATE FIRST LAST DATE 2 2 Matthew Johnson 5/2/2015 3 2 Mark Anderson 2/7/2014 4 2 Luke Jones...

Hello! I have a challenge for you geniuses. I am trying to sort my column with an INDEX-MATCH formula. The Formula is pretty standard: INDEX(Formulas!$AL$9:$AL$196,MATCH(Standings!C7,Formulas!$C$9:$C$196,0),1) The INDEX-MATCH is pulling results of another formula from another sheet. That...

I have attached an example file, with working vlookup formula which Im trying to get rid of, so I do not need time to create pivotable to help the formula out. What the working lookup is currently doing: 1) 1st worksheet contains list of settlements with amounts, there might be several...

Hello friends, a long time lurker-first time poster. This place has saved my *** on multiple occasions. Unfortunately, I have now spent days looking for a solution without much luck and felt compelled to ask my first question. The problem at hand is this. I have a list of employees (by ID) and...

I have two INDEX-MATCH formulas that I'm trying to chain together with an IF statement that I was looking for help. INDEX-MATCH 1: {=-IFERROR(INDEX(filtered!A:Y,MATCH(1,(filtered!W:W=W2)*(filtered!J:J=-J2)*(filtered!E:E=E2),0),10),0)} INDEX-MATCH 2...

Hi Everyone, I am working on a document trying to compile monthly purchases of parts for the year. The biggest obstacle I am facing is that the pricing for different parts changes at different points throughout the year. Currently I have one table listing each part with the effective and...

I am creating a spreadsheet that models the sale of some single family homes. I have built a sale schedule that says X of the homes are to be sold per month, and I am then looking to multiply that X number by the appropriate values (the values are not the same, and range from $300,000-$450,000)...

I'm using an 'advanced' VLOOKUP formula (below this paragraph) to let the user find the relevant values based on the input. The user inputs an abbreviation into cell Q10 on sheet 1 which in R10 and downwards a list is then shown giving relevant data from the table that is looked up on sheet 2...

I have two Excel tables formatted as tables, Table1 and Table2. They both have a field "Case Number." Some case numbers are the same in both tables, and some are different. I also have a field in Table1 called Table1Office and a field in Table2 called Table2Office. I want to create another table...