VBA for applying the lookup function to a formulaArray

[Miraun]

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:

Please Login or Register  to view this content.

Produces an error.

Any insight?

[Colin Legg]

Hi,

You've got one too many ) brackets near the end.

Please Login or Register  to view this content.

[Miraun]

...facepalm...

Thanks