Hello Everyone. I came up with this formula but I have a little dilemma here. Because sometimes I need to swap every three columns, I need a formula that will always point me to the data on the second column to the right of the reference column. My formulas in O5:O10 will no longer work in case I move columns B, C and D (I always move all 3 columns at once)
Cell Formulas | ||
---|---|---|
Range | Formula | |
O5:O10 | O5 | =LOOKUP(1,$B$1:$M$1,D5) |