RobbieJannoh914
New Member
- Joined
- Feb 16, 2017
- Messages
- 3
Hello,
This is my first time posting here and I've searched everywhere to find the resolution to my issue but was unable to find a solution.
I am trying to get B1 to bring back the value in Column F based on multiple criteria: (A1 is >= D:D and A1 <= E:E and C = "Collared")
If we do this formula, B1 should 4.00
Unfortunately I haven't been able to form a proper index match formula, or an indirect match formula. Is there a combination of formulas that I can use to get this solution?
Please advise.
Please see table below for example
<tbody>
</tbody>
This is my first time posting here and I've searched everywhere to find the resolution to my issue but was unable to find a solution.
I am trying to get B1 to bring back the value in Column F based on multiple criteria: (A1 is >= D:D and A1 <= E:E and C = "Collared")
If we do this formula, B1 should 4.00
Unfortunately I haven't been able to form a proper index match formula, or an indirect match formula. Is there a combination of formulas that I can use to get this solution?
Please advise.
Please see table below for example
A | B | C | D | E | F | |
1 | 3/1/2015 | Collared | 1/1/2015 | 1/31/2015 | 3.00 | |
2 | Fixed | 2/1/2015 | 2/28/2015 | 4.00 | ||
3 | Collared | 3/1/2015 | 3/31/2015 | 4.00 | ||
4 | Collared | 4/1/2015 | 4/30/2015 | 5.00 | ||
5 | Fixed | 5/1/2015 | 5/31/2015 | 3.00 |
<tbody>
</tbody>