Q:

index arrayformula

=arrayformula(vlookup(F1:F, {row(x!C2:C) - row(x!C2) + 1, x!C2:C}, 2))
0

New to Communities?

Join the community