1. E

    How to use formula result in one cell in formula range in a different cell?

    In U1, I have =MATCH(U2,$A$1:$A100,0) which returns a correct value of 2. In U11, I have =MATCH(TRUE,INDEX($B3:$R3<>"",0),0) I'd like to change the $B3:$R3 to use the value in U1. Something like: "$B"&U1+1&":$R"&U1+1 But so far all I'm getting is #VALUE errors! Anyone drop-kick me in the...

Some videos you may like

This Week's Hot Topics