match - if

I need a formula that in column F will search and match a table where Column I's value is within Column A and make F egual to the equivalent value in J. I've tried search, match and Vlookup to no luck. Eg, I2 is within A2 so B2 should equal to J2 I3 is within A5 so B5 should equal to J3

Hi everyone, I am trying to match day and month between two dates, as mentioned below these dates do not have years only Day and month. for example B C D B3 = Start Date...

Excel Champs, Looking for creative solves for the below problem. I have a project sheet that looks something likes below in a table. I need a button function that can transfer in a separate sheet all the values in that row for that project transposed in a column. Master file (Sheet 1)...

I have test data that comes in like the original file format example for each student, with their ID number in column A, question number in column B, and answers in column C. In order to upload the file I need to get it in the following format: ID,answer,answer,answer,etc.. <tbody> A B C D...

Hello everyone, First post here. I have a problem and hopefully you guys can help me out. I have two sheets Sheet 1 is the transpose destination after a row has been matched. <tbody> <tbody> CA Nber Transpose Destination </tbody> <tbody> Net Nber </tbody> <tbody> Effective...

I am trying to add an IF condition to an Index/Match formula. Row 3 is a list of Dates (AZ$3) Row 8 is a list of Dates I am trying to match Row 3 to Row 9 is a list of $ values to return when a date in Row 3 matches a date in Row 8. When the dates match the correct value is returned. When...

Hi! I am trying to create an IF formula with two INDEX MATCH formals within it. ie. if a cell says one thing use INDEX MATCH A otherwise use INDEX MATCH B. This is the formula I have written and it is still not pulling correctly. =IF(BH7="#N/A",(INDEX('[File A]Sheet1'!$G:$G,MATCH(D7,'[File...

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 All, I cannot find the simple way of how to get the position (row number) of the k-th value for the functions like SMALL(array, k). please find an example: <tbody> value k k-th smallest 1 1 1 2 2 1 1 3 2 3 4 3 4 5 4 </tbody> Formula in C2 is the following: =SMALL($A$2:$A$6,B2)...

Hi, I have this table ... this is a part of millions of records. I have functions that show if STAT is 1 or 0, if type is E, if type is CA. This example shows that the same work 24188686 has one E and two CA. If I filter columns I can see either E or CA from the same work. I would like to...

Hi All, I am putting together a report that can be automatically repeated on a monthly basis from budget reports that I receive at the start of each month (which I'll call 'Budget Report'). I have managed to calculate the first value I need: the number of placements I have in a particular...

Employee-Leave-Vacation-dashboard.xlsx Hey Folks, Please I need your help to fix one issue in the attached excel file. Sheet TEAM DASHBOARD, I want to add INT fuction to calculate only date from vacation & absence sheet without time. I'm looking also to get data from the 2 table ( Vacation &...

I'm not terribly good with VBA, so this is probably a silly question...I took a look through the forums, but couldn't figure it out... In worksheet-A, I have a single cell with criteria that I want to look up. Say "Match2". In worksheet-B, there are a bunch of data rows. I want to put all of...

I'm having trouble inserting and extra if function at the beginning of my formula. I have a 'Job sheet' which informs my workshop of what to produce based on what has been quoted (information for the job sheet is gathered from another sheet in the same workbook). Currently, I have the...

An Excel spreadsheet currently exists which has several years worth of data. In the past, exclusion codes were eight characters in length and they were always at the end of the comment. The previous formula worked fine before the exclusion codes were changed and the method of entering the...

Hello all, I wasn't sure exactly how to describe this problem and I suspect the solution is simple (however, I have been pulling my hair out trying to find it). We have a bunch of salesmen participating in a variety of sales events. We are trying to find the sum of the outputs by pairs of event...

I wonder if someone could help, I have two supplier lists. The first has the correct supplier spellings and supplier references. The second is a creditor listing from a different system which has the same suppliers and different account numbers. The supplier names differ slightly eg limited...

<tbody> ID Date ID Date 1 1/1/2015 1 1/11/2015 ? 1 1/10/2015 2 2/17/2015 ? 1 1/14/2015 3 4/5/2015 ? 2 2/4/2015 2 2/8/2015 2 3/11/2015 3 4/1/2015 3 4/7/2015 Hi: I would like to have a formula that will look through a list of dates (column 2) and return the...

I've been playing around with this for 3 days now and still no luck:confused:. Everyone I talk to has a different method (VLOOKUP, HLOOKUP, INDEX & MATCH) but none to seem to work just right. Any help would be greatly appreciated before I pull my hair out. Here is what I am trying to accomplish...

<tbody> PDR rating OP VE EP/DP MP PP % Bonus payable CBD 12.00% 10.00% 8.00% 4.00% 0.00% CBM 9.00% 7.50% 6.00% 3.00% 0.00% CDE / CDM 5.00% 4.00% 3.00% 1.00% 0.00% </tbody> I need to return a value if certain crietria is met i.e OP & CBD, however the...