How to use a column name in formula reference

Question

I am using the following formula in columns across where each new column is the next month.

'XLOOKUP("*"&$A2&"*",'[Sales by Item 2025-01.xlsx]Sheet1'!$F:$F,'[Sales by Item 2025-01.xlsx]Sheet1'!$I:$I,0,2)

How do I use the Column name in the XLOOKUP function so I do not have to edit each cell for each new months linked reference?

SKU	2025-01	2025-02
ABC-123	XLOOKUP formula using "ABC-123" and "2025-01"	XLOOKUP formula using "ABC-123" and "2025-02"

hansvogelaar · Answer

See Build formula using date label for workbook link where I replied to more or less the same question.

Forum Discussion