Hello,

=B1:INDEX(B:B,A1)

is non-volatile - meaning that it does not recalculate each time you
press F9 unless A1 changes.

Regards,
Bernd