Forum Discussion
null null
Feb 28, 2018Copper Contributor
Excel formula help
Hello! I used this formula successfully on a cell: = If (A2 = "MA1"; sheet1! D1; sheet2! B1)
Now, I want to apply the same formula on the other cells of the lower lines so that it ...
SergeiBaklan
Feb 28, 2018Diamond Contributor
Instead of "MA1", "MA2", etc you may use something like
"MA" & ROW()-1