79105905

Date: 2024-10-19 20:51:32
Score: 2
Natty:
Report link

It works with the function INDIRECT:

=INDIRECT("Lookup_Sheet!A" & ((ROW() + 3) / 4)+1)

Lookup_Sheet!A2 is given to Protocol!A2

Lookup_Sheet!A3 is given to Protocol!A5

Lookup_Sheet!A3 is given to Protocol!A9

and so on.

Reasons:
  • Low length (0.5):
  • No code block (0.5):
  • Self-answer (0.5):
  • Low reputation (0.5):
Posted by: Yahalnaut