Forum Discussion
Formula to Skip Cells
I need help creating a formula to return values from a single cell to multiple cells (repeated) and to return values to nonconsecutive cells. So far I have created three which do one or the other but...
OliverScheurich Thank you so much. That looks perfect. What would I change to make it duplicate/repeat the values every four cells instead of returning blanks for 3?
=INDEX(H$2:H$8,MATCH(LEFT($A2,3),LEFT($G$2:$G$8,3),0))
You are welcome. If you want to return the result 4 times you can apply this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.