building a table based on an other table

I have a table (Table-1) which contains two columns. Column -1 has a date and Column-2 has an amount. Column-1 is in date sequence but can have multiple entries for the same date.
I want to build another table (Table-2) where Column-1 is already populated with a date. This table is in date sequence and has no duplicate dates.
I will like to populate the amount (Column-2) in all rows of Table-2 from Column-2 of the last, or the only, Column-1 matching row of Table-1 (i.e. same date in Column-1 of both Table-1 and Table-2).
Can I do this without VB? Any help will be appreciated.

Capture.GIF


Note that Table-1 does not have an entry for Jan-4 and In Table-2 the Amount is therefore duplicated from Jan-3

This should work in G2
=IFERROR(INDEX($D$2:$D$7,SUMPRODUCT(MAX(ROW($C$2:$C$7)*(F2=$C$2:$C$7))-1)),G1)
Drag down to fill below. You'll want to change the 7's to wherever the end of your real list is...
* Edited - Sorry, I had the wrong columns

I tried but getting incorrect values. Most likely I have made in error in editing the formula to change column numbers. Please have a look.

It is Col-P starting in Row-4 that I am trying to populate from values in Col-I after matching the dates in Col-K and F. So I changed the formula as follows:

Orginal Formula: IFERROR(INDEX($D$2:$D$7 , SUMPRODUCT(MAX(ROW($C$2:$C$7 ) * F2=$C$2:$C$7 ))-1)),G1)
Edited Formula:- IFERROR(INDEX($I$4:$I$700,SUMPRODUCT(MAX(ROW($B$4:$B$700)*(K4=$F$4:$F$700))-1)),p3)

As you can see, the Colum-P value for Sep 4 is incorrect.

Capture2.GIF

Great! It works now. Thanks very much.

Edit to document another solution I found:

=IF(ISNA(LOOKUP(2,1/(F$4:F$700=K4),I$4:I$700)),L3,(LOOKUP(2,1/(F$4:F$700=K4),I$4:I$700)))

In this case it is Col-L, rather than Col-P, that is the target.