I have a named table (RMDTable) with columns that I want to add based on the date in column A (Tax Year Ending). The sum will go in a cell in a different sheet/table.
I'm currently successfully using this formula: =SUM(VLOOKUP([@[Tax Year Ending]],RMDTable[#Data],{6,7,10,11,18},FALSE))
But those columns (6,7,10,11,18) could move, and I think the spreadsheet would be better documented if I could replace those column numbers with their structured reference names.
I tried replacing the column numbers within the array within the VLOOKUP with the column names (e.g., "IRA 1 Conversion", "IRA 1 Withdrawal", "IRA 2 Conversion", "IRA 2 Withdrawal", etc.) but cannot get the formula to accept either the column name as RMDTable[IRA 1 Conversion] OR as COLUMN(RMDTable[IRA 1 Conversion]).
Is there a way to reference the column by its name, rather than its position number, in the formula that am currently successfully using?
I'm currently successfully using this formula: =SUM(VLOOKUP([@[Tax Year Ending]],RMDTable[#Data],{6,7,10,11,18},FALSE))
But those columns (6,7,10,11,18) could move, and I think the spreadsheet would be better documented if I could replace those column numbers with their structured reference names.
I tried replacing the column numbers within the array within the VLOOKUP with the column names (e.g., "IRA 1 Conversion", "IRA 1 Withdrawal", "IRA 2 Conversion", "IRA 2 Withdrawal", etc.) but cannot get the formula to accept either the column name as RMDTable[IRA 1 Conversion] OR as COLUMN(RMDTable[IRA 1 Conversion]).
Is there a way to reference the column by its name, rather than its position number, in the formula that am currently successfully using?