HELP PLEASE - Search Formula with DATE

[Paulo Delgado]

Hello Excel Masters!

Could you help me please?

I attached an excel file were i would like some help.

On the first line i have several dates and on the second line i have price.

I would like to fill the 2nd line with the correspondent price for the table below the the two initial lines.

So for the first date, the formula have to identify in which period will correspond and then identify the price in front.

Is difficult to explain in english for a portuguese guy!

But any questions, i will try to clarify.

Many thanks in advance!
Paulo

 

[Logit]

=LOOKUP(2,1/($A$8:$A$16<=B1)/($B$8:$B$16>=B1),$C$8:$C$16)

Paste in B2 and drag over to K2.

 

[p45cal]

or:

=INDEX($C$8:$C$16,MATCH(B1,$A$8:$A$16))

or:

=VLOOKUP(B1,$A$8:$C$16,3,TRUE)

 

[Paulo Delgado]

Hello!

Thank you very much for your help!

Living and learning!

 

[Logit]

You are welcome.