Entering Index Match Match using VBA referencing table sections.

[TXRChav]

I have a macro that was running into issue mainly due to using the .select too much so I am trying to remove it from my code wherever possible, but I am unsure how to rewrite the following formula:

Range("L9").Select
ActiveCell.FormulaR1C1 = _
"=INDEX('Previous Data'!R1C1:R34C6,MATCH([@[Incident ID*+]],'Previous Data'!R1C1:R34C1,0),MATCH(Table_ReportingTickets[[#Headers],[BA Priority]],'Previous Data'!R1C1:R1C6,0))"



Thanks for your help.

 

[Norie]

Just replace ActiveCell with Range("L9").

Range("L9".FormulaR1C1 = _
"=INDEX('Previous Data'!R1C1:R34C6,MATCH([@[Incident ID*+]],'Previous Data'!R1C1:R34C1,0),MATCH(Table_ReportingTickets[[#Headers],[BA Priority]],'Previous Data'!R1C1:R1C6,0))"