index match

Hello all, Context: I am working on a spreadsheet for our PMO to automatically enter data from a CSV file into a large table of agent working hours, then calculate the project's budget in a Pivot Table for their reports. They have been very thrilled with the results, however, there is one...

I dont know what ive done wrong to my index match statement. I need to get monthly earning into a column. each person has 12 months in a row. On a separate spreadsheet I have the dollar amounts per month for each person. I need an index match statement that will put the 9.50% in the column...

Hi, I have the following spreadsheet, which lists all payments made under client accounts by date. (Please excuse the horrible layout). <tbody> A B C D E 1 Row number Client Name Payment Date Payment Amount True or False 2 2 Dominic Holden 20/04/2018 £6.58 TRUE 3 3 Gary Baines...

Hello! I want to use INDEX MATCH using Table 1 to create Table 2 that displays only "Winter" and sorts the month alphabetically. I used the following formula which did a great job of sorting by month, but I can't figure out how to get it to select only "Winter"...

This is an odd case I know, but given a ton of data in this sheet, I need to perform the goal without having to rearrange the data or use VB/macro. The areas of concern are in bold red... Trying to match E3:F7 with I7:R7 (in this case should = 0,1,3,4), and then see if those matches...

Hello everyone, So I am struggling to fill out the table as attached. I want cells to return values from individual tables matching the date on top of each table to the date on row 2 and to match items from column B to each individual table depending on the first match (dates). It is...

Hi I have not used either of the formulas before but would like to learn the basics. in my 2 worksheets, I have information about the same staff but each worksheet refers to different budget. I started entering on worksheet 1 if the staff is current or ex (column exited - if staff left there...

Hey all, Context: I am in the process of developing a learning game for a training class at work. It's based on the concept of the Around the World game we have likely all played with a Basketball. In the game, players/teams move forward or backward depending on their ability to answer...

I have the following sheet: Column B S U Style Number Item Number Available QTY I have tried to index match this via various methods and cannot get this working. What I want to happen is that when B=S only show those items which...

Hi, I have the array formula below that is working correctly. =IFERROR(INDEX('Roadmap'!$H:$H,MATCH(1,($A$3='Roadmap'!$D:$D)*(C$3='Roadmap'!$E:$E),0))&"","No Content Found") What I need to do is add one additional lookup criteria that I can't quite figure out. On the Roadmap tab there...

I have a spread sheet with hundreds of part numbers, SKU, and matching photos. I need to be able to show the correct image based on the SKU. It can be index match, vba, vlookup, I'm find with anything. The only things I've been able to find online use a drop down list and this will not work for...

I am new to index match as I just recently downloaded Excel 2016 and I am beyond lost. For context, I will be adding my formula to cell Q3 and dragging it down. Sheet 2 runs from A1-N25435 I am trying to look up an ID Number (sheet 1, column B) and return of the requisition number(s) (sheet 2...

Dear All, Lets say i need to lookup the value of a particular cell in a row contained in Sheet 1. There are three other sheets; namely Sheet 2, Sheet 3 & Sheet 4 where this value needs to be searched for. Now, on a serious note, what would be the formula using index match for looking up the...

Hi, I'm trying to pull in the Employee Name based on a Manager's ID Number. For example, if I type in 1234 - I want the table below to fill out with all of her direct reports. But with Index Match, it only pulls in the first result. Is there a way to pull in the new next result and keep going...

Dear Experts, Please look into the attach file frmula index match could not perform very well and where is duplicate of marks formula does not pick up name of student and make some error repeat two time..... https://1drv.ms/x/s!Ar_1OKzm7QW1fm4AUrX7VPiLmlA Please help to resolve this formula...

Hi all, I'm hoping you can help me out. I have a question about SUM INDEX MATCH for items in a row: <tbody> PPTD PPTD PTD PTD PTD PTD PPTD Customers 70 81 80 94 75 249 151 </tbody> The last two columns should total the others if there is a match to the column heading...

I have 2 spreadsheets. One is the Master, the other is called Export. I need to get the numbers from the export into the master (column C) each month based on the item row name and the IDs in column A need to match. I kept trying: IF column B CONTAINS this, then pull in column T from other...

Hello! I am trying to get the product names by store that are the "bottom 3" in the following table: <tbody> Product Store Budget %Achieved Soda A 10.00 46% Juice A 20.00 0% Coffee A 25.00 0% Water A 30.00 0% Tea A 40.00 0% Soda B 5.00 10% Juice B 15.00 90% Coffee B 60.00...

Greetings all, I'm running into an issue with part of an INDEX MATCH array and don't know how to resolve it. Context: Manager asked that I setup a table to calculate the average calls offered to agents on a 30 day rotation against the days they are WFH (work from home). So, I need needed to...

Hi friends, I am working on a project where I would need below raw data to show expected results as shown below. Basically, it is an outlier report where only "Check Accts" will be flagged. Thanks!!! I am looking for the formulae without {} brackets, it maybe combination of Index Match...