Hi, I am very new to Calc, so my knowledge is somewhat limited. Cell J1 contains a number in a range A2:A2000. Lets say that number is 232, I need to copy the contents of A232:C232 to K1. Thank you
Hallo
=INDEX($A$1:$C$2000;J1)
put it into »K1« and enter with ctrl ⇑ enter
2 Likes
Thank you Karolus, your solution worked well. Very much appreciated.