Help ! With INDEX MATCH function

Originally Posted by GC Excel

Maybe this :

Range("S2").FormulaR1C1 = "= INDEX([PatientMerge.xls]2015!C10,1)Match([PatientMerge.xls]2015!RC[-16],C10,0))"

if it does not work, type your formula in a cell, then go in the VBA Editor, open the Immediate Window (CTRL+G) and type: ? Activecell.FormulaR1C1

I got
Run-Time error '1004':
Application-defined or object-defined error