This string returns #N/A:

=VLOOKUP(LARGE('Price List'!B3:B44,1),'Price List'!$C$3:$H$44,6,FALSE)

First need to identify the LARGEST value(in this case the most recent
date) then bring in corresponding data such as the next price-breaks.

To find the 2nd most recent date and its price: the next line, would
read:

=VLOOKUP(LARGE('Price List'!B3:B44,2),'Price List'!$C$3:$H$44,6,FALSE)

Its apparent I cannot do this in a single cell.

TIA for any ideas.

Pierre