Distribute the row of a reference evenly when copying and pasting formulas in excel? (Pic included)-CodePudding

Home > database > Distribute the row of a reference evenly when copying and pasting formulas in excel? (Pic included)

Distribute the row of a reference evenly when copying and pasting formulas in excel? (Pic included)

Time：01-29

So I'm trying to spread this list out between gaps but the row number in the formula keeps skipping ahead.

I want to copy the =$A1, and when I paste it I want it to to show up as =$A2 instead of =$A4 because of the gaps.

=IFNA(INDEX($A$2:$B$1001;MATCH(F5;$B$2:$B$1001;0);1);"")