i have 2 input criteria contain a date between two columns

Code start date end date growth rate
304 1/3/2017 2/9/2017 3.5
203 1/4/2017 2/9/2017 3.2
307 5/5/2017 2/9/2017 2.7
307 2/4/2017 5/5/2017 2.3
123 2/2/2017 5/5/2017 2.2
307 1/1/2017 5/5/2017 1.5
204 2/9/2017 10/20/2017 1.1


in this example,

the inputs are: code#, a date of start and a date of end
the output is: the growth rate.


any help with explanation please??!

Hello and welcome to the forum.

What are you asking for? An explanation of what?

thanks alot, pleasure to join the forum

my question is how to lookup the growth rate corresponding to a code# and date falls between the start and end dates

i tried the index match formula but u couldn't make it,

" note that i am a beginner" so if you help me to understand if you got my question

thanks inadvance

The sample that you showed in post #1 has overlapping dates for the same code.

For example, what growth rate would you expect for code 307 with a date of 2/20/2017?

Also, note that row 4 (of your sample in post #1) has a start date after the end date.

sorry for that, i just tired to make a sample of my own,

i will extract sample of live data and post it
sorry for my convenience :$

When you do post your sample, upload an actual Excel workbook (not a picture) showing the data along with the desired result (manually entered) of a formula.

To upload a workbook, go to Go Advanced > Manage Attachments > Choose File > Upload > Close this window.

i have uploaded a reviewed data

i hope this describes what i want to do,

and thank you alot for your support and your concern

Thanks alot for you help, it worked