karthick019
New Member
- Joined
- Jul 15, 2011
- Messages
- 10
Dear all,
My question is based on the sample table below,
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I need a formula with 2 criteria's where part number is matched directly and i have a date and need to find the closest minimum range and update the price for the same.
Eg,
When I enter Part number as "A" and Date as "05/09/2012". the price should be matched as below,
(Part=A) & (Date = closest minimum date) ie. "01/03/2012" in this case.
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I tried searching for this but I am left with no answers. Help me out excel experts.
My question is based on the sample table below,
Part | Date | Price |
A | 01/01/2010 | 100 |
A | 01/05/2010 | 200 |
A | 01/01/2011 | 300 |
A | 01/03/2012 | 400 |
A | 01/04/2013 | 100 |
B | 01/04/2010 | 600 |
B | 01/06/2011 | 700 |
B | 01/08/2012 | 800 |
B | 01/09/2012 | 900 |
B | 01/04/2013 | 100 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I need a formula with 2 criteria's where part number is matched directly and i have a date and need to find the closest minimum range and update the price for the same.
Eg,
When I enter Part number as "A" and Date as "05/09/2012". the price should be matched as below,
(Part=A) & (Date = closest minimum date) ie. "01/03/2012" in this case.
Part | Date | Price |
A | 05/09/2012 | 400 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I tried searching for this but I am left with no answers. Help me out excel experts.