array formula in vba debugging error

**lilsnoop** · 05-31-2021, 12:36 AM

Was hoping someone could assist me with making this formula work in vba:

Please Login or Register  to view this content.

It worked prior to adding the if statement, but I need the if statement to be part of the array if at all possible. Appreciate any assistance.

**Bo_Ry** · 05-31-2021, 01:26 AM

Maybe try

Please Login or Register  to view this content.

**lilsnoop** · 05-31-2021, 01:40 AM

Thanks Bo_Ry! I believe that did the trick for me! Really appreciate your help!!

Re: array formula in vba debugging error