2 criteria

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

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

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

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

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

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

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

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

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