Hello geniuses,
Could anyone please help me figure out what I got wrong in this ActiveCell.FormulaArray code?
Been at it for an hour trying to find where the error comes from 
ActiveCell.FormulaArray = _
"=IF(INDEX('Review Archive'!C6,MATCH('Request Status'!RC[-4]&'Request Status'!RC[-5]&'Request Status'!RC[-1],'Review Archive'!C2&'Review Archive'!C1&'Review Archive'!C5,0),0)=0,"""",INDEX('Review Archive'!C6,MATCH('Request Status'!RC[-4]&'Request Status'!RC[-5]&'Request Status'!RC[-1],'Review Archive'!C2&'Review Archive'!C1&'Review Archive'!C5,0),0)))"
Thanks in advance
Bookmarks