Hello,

applied to your attached file, Daddylongleg's formula needs to be adjusted to your ranges as follows:

=IF(A1<'PRICE POINTS'!A$1,'PRICE POINTS'!A$1,INDEX('PRICE POINTS'!A$1:A$70,MATCH(A1,'PRICE POINTS'!A$1:A$70)+(LOOKUP(A1,'PRICE POINTS'!A$1:A$70)<>A1)))