INDEX, COLLECT, CONTAINS Formula help

Beth C

Hi!

I have a formula that is working the way I want...

=IFERROR(INDEX(COLLECT({LFH Date}, {LFH Date}, @cell > TODAY(), {LFH Analyst}, Name@row), 1), "")

But when I add another condition, I get #INCORRECT ARGUMENT SET. This is the formula:

=IFERROR(INDEX(COLLECT({LFH Date}, {LFH Date}, @cell > TODAY(), {LFH Analyst}, Name@row, {LFH Location}, CONTAINS("Home", @cell)), 1), "")

Any ideas on what may be the problem?

Thanks!

KPH

The formula looks good. Can you click on the cell with it in, as if you were editing it, and take a screen shot?

Beth C

Hi KPH,

Thanks for the response. I ended up making a helper column in the source sheet that showed LFH Analyst if Location contained "Home." There's always another way, correct? 😁

KPH

Glad you got what you needed :)