index match 2 criterias

Hi everyone! I have two reports that I merge based on a unique identifier from Report A (database) which is normally present in Report B (ticket system report), but not always. The Merge ends up with two columns with employee names (one from Report A and one from Report B). From this merged...

I am using Index match function in excel to retrieve values from a sheet ("MasterData") to another sheet ("Report") using a specific unique number which the user enters in a cell in sheet "Report" . This populates a table with about 6 columns and 15 rows as per the data available in...

Hello All, I am a little new to this excel forum thing, am self taught, so apologies in advance. I have had a cursory look at some similar forum queries and am unable to work backwards to fix my problem. My original problem: find the 2nd shift code in D132 along a list E$82:E$124 and reference...

Hi Guys, I have been trying to come up with a formula for an issue In sheet one , i have a result sheet where i want return data set from sheet 2. The criteria for choosing the results are 2 fold, based on lookupkeys, then criteria which is country). However the issue is, in sheet two, the...

Hello, I am trying to pull certain data from a raw file that is updated weekly from another source and place it in a more presentable model. I am having to use multiple criteria (Columns A and B) to try and get the appropriate lookup value from Column C through F but am not having much luck...

Hi there, I have a large data set from an export of phone system. In the data set there is data i can pivot tabel to find my results but the format isnt conducive to pivot without some modifications. I need to find the "DNIS:" in column A and also the information in Column B and add the type to...

I'm building an overview spreadsheet that takes information from multiple different reports. The formula I'm struggling with identifies employees by last name while all the other reports use full name (Last, First, MI), so I need to use partial text or wildcards. The report provides a row for...

Hello, I'm trying to pull what a service rate would be based on a position and a specific rate card. For instance I have a list of titles and rates, and a list of titles and rates under different rate cards. I am looking to pull back the rate for a title under a specific rate card. Sheet 1...

Hi i was wondering if i could use index match with IF to find the production volume by matching the delivery date and post it to the relavant month in sales <colgroup><col><col><col><col><col><col><col><col><col><col span="5"></colgroup><tbody> Production Volume Sales Invoice...

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...

Okay let me see if I can explain this...I am looking to match Supplier Name #sheet 1 to Supplier Name #3 If those two suppliers match,then look for the Known Spend, If Known Spend is equal to "Y", then look to see if the they fall within two columns with dates. Now if that all information...

<style type="text/css"> p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'} span.s1 {color: #006107} span.s2 {color: #0057d6} span.s3 {color: #ab30d6} </style>I am working on a project and have been spending hours looking into the excel INDEX MATCH formulas and online tutorials...

I am trying to find out the maximum and minimum values in Index and Match function For example Nodes Sign Moment 1 +ve 54 1 +ve - 10 1 - ve 68 1 - ve - 15 1...

I am working on creating a table that shows the most recent survey information for each project area. On my display page i have the current formula type of =IF(A4="-","-",INDEX('Erosion and Sediment'!A$3:A$1999,MATCH($A4,'Erosion and Sediment'!$B$3:$B$546,0),(MATCH("Newest",'Erosion and...

The changes our building access system and I am trying to build a work around. Our overnight staff swipe in and out of the floor throughout their shift so there are multiple timestamps for each day. I am trying to find the swipe that closest matches their shift time to find late arrivals. I am...

Hi I am trying to check if the cell [@channel] condition is met before doing a index and match function...

Dear Great Minds of Excel, I have the following information: Column A = Vehicle Numbers Column D = Dates of Service Column E = Type of Service A D E A111 01/22 Oil Change A112 01/30 Brakes A113 01/15 Wash A111 01/18 Tires A123 02/05 Oil Change...