2 criteria

  1. M

    Lookup for data with 2 creterias (date and name)

    Hello. I'm going round and round with vlookup, lookup, index, match, sumproduct etc. but can't find the right solution. I have a list with prices for clients and dates from which they start to be active: <tbody> A B C 1 Start_Date Client Price 2 01.06.2016 client1 1 3 01.07.2016...
  2. E

    Populate table given 2 criteria (array function)

    Hi Guys. This is my first forum post, so please bear with me if I ask a bit of a dumb question. I have a dataset that consists of nine headings: (1) Programme; (2) Tracking Area; (3) Indicator; (4 - 9) Countries (e.g. South Africa, France, Columbia, etc.). The dataset is populated with...
  3. R

    Use Index Match to fill in columns Sheet 1 based on data in Sheet 2

    I have Sheet 1 with an account number in column a and column B-Y are different products that each account may own. I would like to have the sheet filled out as seen below. I think I will be able to fill in the X's using Index Match. <tbody> Account# B C D E F G H I J K L M N O P Q R S T U V W...
  4. B

    Table Dynamic Sum 2 Criteria

    I have a table with multiple years and rows of data. Each record for each year has the same number of rows (3) and the same number of columns (13). The issue is that some years can have multiple records, with different header rows for each record. I would like to sum the 3rd row of each year...
  5. J

    Match Index two criteria and return multiple values

    Hello, I am currently using the below formula: =INDEX($B$40:$B$404,MATCH($B$5&$B$11,$C$40:$C$404&$D$40:$D$404,0),1) I am matching b5 & b11 from cascading dependant drop down lists. It works to return the first value I need in column B, but when I copy it down it still returns the same value...
  6. K

    Dynamic table that extracts records that meet 2 criteria (Date Range)

    Hi, I am trying to create a dynamic table that extracts records that fall between a certain date range. I am unable to get the list to populate. My formula is as Follows: {=IF(ROWS(L$9:L9<=$M$2,INDEX(INDIRECT(L$8),SMALL(IF(Add_time>=$C$3,IF(Add_time<=$D$3...
  7. S

    Entering a value when 2 criteria are met - Please HELP!!!

    I'm trying to get a formula that will enter a particular value when 2 specific criteria are met. I've been trying to use an =IF(AND( statement, but so far I keep getting a "the formula you typed contains an error" message. I need to have cell V9 return a value of 8 if the following conditions...
  8. B

    Vlookup based on 2 conditions

    Hi, I am looking to do a vlookup based on 2 conditions and have no idea how to do it. At the moment I am doing a vlookup on a cell in column A and it is producing a particular value, the problem is that this cell appears a few times in column A. So what I need to do is lookup the cell in...
  9. C

    Problems with putting 2 criteria into an autofiler in vba

    (Excel 2003, Windows XP Professional) Hello, I'm hoping someone can help me with the following problem............... I have written vba code in order to perform an autofilter between two dates, however my macro is not giving any results. If I step through the code, go into excel itself and open...

Some videos you may like

This Week's Hot Topics