Finding the Max Lookup Between Tables

[Anonymous]

Morning all!

I am pulling in the latest price for a particular contact. the contact had three months of activity. 

May 

June 

July

Pricing in July Changed from $2.00 to $3.00 so in May and June the pricing is the same. However when I try to pull in pricing based on table 1, since there is no June date it is left blank in table 2.   

Question, how do I pull in the last max date (which is May pricing) for June.

Table 1
Date	Contract #	Price
5/1/2020	P-2030	$ (2.00)
7/1/2020	P-2030	$ (3.00)

Table 2
Date	Contract #	Seller Name	Price
5/1/2020	P-2030	ABC Corp	$    (2.00)
6/1/2020	P-2030	ABC Corp
7/1/2020	P-2030	ABC Corp	$    (3.00)

[lbendlin]

Use LASTNONBLANKVALUE() to get the May data for June.