Hi All,
First, thanks to all that help and post to the forums. I hope someone is able to help me as well. I'm using a mechanic's shop as an example because it is a simple representation of what I'm trying to achieve. I want to pull a unique list of vehicle models that visited the shop within a date range and by vehicle type.
<tbody>
</tbody>My formula attempt resembles this: =INDEX($A$2:$A$9,MATCH(1,($C$2:$C$9>=C11)*($D$2:$D$9<=D11)*($B$2:$B$9="Truck"),0)). It results with the F150 but if I drag it to other cells they all result in F150. In this example, the desired list is in the same worksheet but in my actual file the data is in another worksheet. I am familiar with how to reference another worksheet so that part shouldn't be a problem. I'm currently using Excel 2007.
It seems that I may be missing a COUNTIF statement but I'm not sure. Any help offered will be greatly appreciated!
First, thanks to all that help and post to the forums. I hope someone is able to help me as well. I'm using a mechanic's shop as an example because it is a simple representation of what I'm trying to achieve. I want to pull a unique list of vehicle models that visited the shop within a date range and by vehicle type.
1 | A | B | C | D | E | F |
2 | Model | Type | Date In | Date Out | Desired List | |
3 | F150 | Truck | 4/1/2015 | 4/5/2015 | F150 | |
4 | Taurus | Car | 4/2/2015 | 4/4/2015 | C1500 | |
5 | Malibu | Car | 4/3/2015 | 4/4/2015 | F250 | |
6 | C1500 | Truck | 4/5/2015 | 4/8/2015 | ||
7 | Accord | Car | 4/7/2015 | 4/8/2015 | ||
8 | F250 | Truck | 4/7/2015 | 4/9/2015 | ||
9 | C2500 | Truck | 4/7/2015 | 4/12/2015 | ||
10 | ||||||
11 | Report Date Range | 4/1/2015 | 4/9/2015 |
<tbody>
</tbody>
It seems that I may be missing a COUNTIF statement but I'm not sure. Any help offered will be greatly appreciated!