How To Use Index Match With Named Ranges In VBA

I have two columns both of which lengths will vary depending on the time-frame entered by the user but will be the same as each other for each run of the code. Because of that, I'm trying to create a named range for each column and then execute an Index Match with an Offset off of it. Below is my code which results in an "Object required" error message.

Code:
Dim Ticker As Long, Tick As Range, TIK As Range, RoleDt As Long, RD As Range, endDate As Variant
Ticker = Range("F" & Rows.Count).End(xlUp).Row
RoleDt = Range("E" & Rows.Count).End(xlUp).Row
Set TIK = Range("F2:F" & Ticker)
Set RD = Range("E2:E" & RoleDt)
cell.Formula = "=INDEX(RD,MATCH,(RC[-1],TIK,0)+1)"