Hi,
I need to lookup value in table and return value based on date range.
my table look like that:
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>In other sheet i have list of numbers such as the numbers above (in column A) with specific date, based on that i need to return the model that was between that time.
for example for number 110 in the date 1/1/2010 the model was C.
is there any function that can do that or even macro that can help in that case.
thank you in advance
Samuel
I need to lookup value in table and return value based on date range.
my table look like that:
Number | Date1 | Date2 | Model |
109 | 02/12/2003 | 29/07/2005 | A |
109 | 29/07/2005 | 23/11/2009 | B |
109 | 23/11/2009 | 11/11/2010 | C |
109 | 11/11/2010 | 19/12/2010 | D |
109 | 19/12/2010 | 25/04/2013 | E |
109 | 25/04/2013 | 24/03/2015 | F |
109 | 24/03/2015 | 28/12/2050 | G |
110 | 02/12/2003 | 29/07/2005 | A |
110 | 29/07/2005 | 23/12/2009 | B |
110 | 23/12/2009 | 02/11/2010 | C |
110 | 02/11/2010 | 19/12/2010 | D |
110 | 19/12/2010 | 21/03/2013 | E |
110 | 21/03/2013 | 24/03/2015 | F |
110 | 24/03/2015 | 20/05/2015 | G |
110 | 20/05/2015 | 26/05/2015 | H |
110 | 26/05/2015 | 28/12/2050 | J |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
for example for number 110 in the date 1/1/2010 the model was C.
is there any function that can do that or even macro that can help in that case.
thank you in advance
Samuel