Hey Everyone;
Very quick question here, I received a formula that I will be using in my workbook:
=SUM(IF($A2=data!$O$2:$O$238,IF(B$1=LOOKUP(TODAY()-data!$H$2:$H$238,{0,181,365,730,1095;"<180","181-360","1-2 Years","2-3 Years","3+ Years"}),1)))
However, I don't know if there are other characters I need to use for the brackets as part of the Lookup array when writing it into VBA:
Produces an error.Sheets("Graph Reference Area").Range("B2").FormulaArray = "=SUM(IF($A2=Data!$" & Id & "$2:$" & Id & "$" & DR & ",IF(B$1=LOOKUP(TODAY()-Data!$H$2:$H$" & DR & ",{0,181,365,730;""<180"",""181-360"",""1-2 Years"",""2+ Years""})),1,0),0))"
Any insight?
Bookmarks