How to use Excel Offset function where the reference cell is a formula output?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
0
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!
microsoft-excel worksheet-function
share | improve...