I have a formula =OFFSET($AL$5,12,0) that gives me the value I want from column AL. I want to make the "$AL$5" part dynamic, and looked up to match the same value in column F.
=(CELL("address",INDEX(AL:AL,MATCH(F2,$AL:$AL,0)))) outputs "$AL$5"
But when I try to combine the two formulas, Excel errors out: =OFFSET(CELL("address",INDEX(AL:AL,MATCH(F2,$AL:$AL,0))),12,0)*100
Does anyone know how to make this work? Thanks in advance!