Hi --
I am using the INDEX function to pull values from a named range on another tab with matching row and column headings.
Example formula is:
=INDEX(DebtOther,MATCH($A12,INDEX(DebtOther,,1),FALSE),MATCH(CM$2,INDEX(DebtOther,1,),FALSE))
Where:
DebtOther = named range on another tab
$A12 =...