I have a cell with the formula
=XLOOKUP(A7,'Dec20'!A7:A21,'Dec20'!D7:D21)
which I want to change so that the Dec20 part of the formula is derived from a month referenced in another cell eg K1 with 31/01/21
I can get 'Jan21'! via ="'"&TEXT(K1,"mmmyy")&"'!" but I can't manage to successfully concatenate that into the formula to replace 'Dec20'!
=XLOOKUP(A7,'Dec20'!A7:A21,'Dec20'!D7:D21)
which I want to change so that the Dec20 part of the formula is derived from a month referenced in another cell eg K1 with 31/01/21
I can get 'Jan21'! via ="'"&TEXT(K1,"mmmyy")&"'!" but I can't manage to successfully concatenate that into the formula to replace 'Dec20'!