keeping data locked

[DutchExcelLover]

=ALS(MAAND(VANDAAG())=1;X.ZOEKEN(A4;WorkoutJan23[Oef];WorkoutJan23[1RM]);X.ZOEKEN(A4;WorkoutJan23[Oef];WorkoutJan23[1RM]))
is the formula I am using to get some data from Januari (1). I have this in multiple colums with different months
What I don't want is , if it becomes Februari the data will disapear.
How can I keep the data as they were in Januari?
Tnx

 

[sijpie]

Remove the IF() part:
=X.ZOEKEN(A4;WorkoutJan23[Oef];WorkoutJan23[1RM])

By the way, most users here are used to the English formula notation. So your your Duthch formulas and notation will be difficult to understand.
To quickly find the English notation of a formula, go to VBA editor and run this macro:

Sub GetFormula()
    
    Debug.Print ActiveCell.Formula
End Sub

The formula will be shown in the 'Immediate window' bottom left