index / match

Hi, I am trying to index the column headers (B1:E1) when they match colour (I3:I8), and have a value greater than 0. I would like to match all valid results and not just the first too please. An example of the results I am after are in J3:J8. Any help greatly appreciated...

Hi All, this is my first time posting here. I have done a lot of google searching but i haven't found exactly the problem to my issue. I have multiple sheets which i want to add across. the rows and columns are not in the same order, therefore, a simple sum across sheets wont work. I want to...

Hi All I want to return the cross reference of 2 named ranges. There is a sheet called Front Page where i want to return the result and the information is on a sheet called Commission Row named range = Partner Column named range = Finance Both of the named ranges will be referenced in as...

Hi All, I have a formula with 3 Index Matches, and I want to pick the MAX value of the retrieved results. It doesn't seem to be working...

Hello! I'm trying to create a "transaction matrix" of sorts for expediting the AMEX statement at the end of the month. I've got columns designated for my full employee's names, with rows going to shortened purchase names. For instance, "Uber Xasdqb239871-0-X" was shortened to just "Uber". I...

Hello, Hoping that someone could assist! I have a workbook where I needed to use the index/match function to source the data. While I was able to successfully complete the formula, I need that the formula also takes into consideration the dates. So for example, if the source data has...

Hi there, I currently have an INDEX MATCH formula which is working across 2 spreadsheets and returning the value of the cell I want it to, but I want it to return the reference of the cell instead of the value it contains. I keep getting different errors when I try to use the address...

I thank in advance and apologize (for the simplicity) to everyone at the same time. I'm very rusty and need nudged in the right direction. I have 2 worksheets. 1 is part numbers need for a job and the 2nd is an inventory list. Obviously i'm looking to match part numbers and they are in a...

I receive a spreadsheet with the information listed below. The spreadsheet has a list of employees, spouse, children with DOB's and packages (Medical & Dental). I want to create a formula that extracts every employee with the relationship 1 without duplicates. My current formula extracts...

I'm looking to return values, numeric, and text from an lookup (index match) from non-contiguous columns in a table. Ex. if Age is greater than 60 return:Last Name | First Name | Age | Full Age (yrs, months, days) <tbody> Smith John A. 67 67 years,8 month(s), 21 Days </tbody> This data would...

First, some background on what I have before we get into what Im trying to do. The Sheet pulls in data from our external database that details different repair orders. Each row has Company Name, Entry Date, Repair Order Number, Notes, etc. This sheet is used to assist in managing these orders...

HI all, am new to VBA excel. some i am trying to use the macro for index match but some am not able to get the that . am using the below formaula . ={INDEX(Sheet2!P:P,MATCH(Sheet1!A2&Sheet1!$O$1,Sheet2!A:A&Sheet2!E:E,0))} Note: Sheet1!$O$1 is constant criteria Please help me with this

Hello All, I have some normative data (what I call Index Scores) that are split by age groups (by decade). The "normal index" score is found by looking up two numbers in a table. I have managed to accomplish this with <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px...

Hi all I have an existing database in a worksheet, with customers arranged down the rows, and variables for the customers arranged along the columns. I then have a separate worksheet which acts as an 'At-a-glance' page whereby you choose the customer from a drop down list and a series of cells...

I need a formula to return a unique list of values in (A3:A6) of values from (D2:D6) that are in the column (E:H) that match the criteria in (B1) and have an "x" in Rows (2:6). Need column searched to change based on value in (B1). Thank you:) <tbody> A B C D E F G H 1 Criteria...

I have two tabs within my 2016 Excel workbook the first is called "Look up" and the second is "Return Value" . The formula I need would search the "Look up" Sheet and return "Test Preformed by" on the "Return Value" Sheet using the "Test ordered In" and "TEST #" as the criteria for the lookup...

I have this input table tracking time spent on various activities over a year (first table below). I want to show it in an output table with rows as days and time slots as columns (see 2nd table below) to get an overview of how time was spent. I can use IndexMatchMatch in I2 for the Aug 3 type...

Hi Everyone, I am trying to figure out a way to get the latest date a which a customer has canceled a subscription. (Our customers come on and off fairly often.) Here's an example of what the data set looks like: <tbody> Account July-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17...

I am trying to find a formulaic way to count individuals by role, who have attainment within a range. I've made a sample data set below. I need a formula to populate the values in the yellow cells. Obviously my data set is 1000's of rows, so I would prefer not to filter and count. Is there a...

Good afternoon, I have searched the forums and was unable to find what I was looking for. Perhaps I wasn't using the proper search verbiage, if this has already been posted, I apologize. I have written 2 Index|Match formulas which are for separate employee locations. The reason there are two...