VBA pasting formula that changes depending on row

Hi, I have a long column of data that has blanks within it.
What I need is to paste formula in all of these blanks that will find the data.

I have a macro that finds the cells and is ready to execute code:

Columns("B:B").Select
    Selection.Find(What:="Total:", After:=ActiveCell, LookIn:=xlFormulas, _
        LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
        MatchCase:=False, SearchFormat:=False).Activate
        
    endRow = ActiveCell.Row - 2
    
    Set rng = Range(Q5, Q99).SpecialCells(xlCellTypeVisible)
    For Each cell In rng
        /CODE HERE
    Next cell

The formula I`d normally se would something like "=VLOOKUP($G5;'RTG%'!B3:P4253;14;TRUE)" which would work with pasting (The number after "G" needs to change depending on row) but I have no idea how to do in VBA.