Index, Collect, with Contains

JSpears

I have tried this multiple ways and it's still not working. Any ideas would be greatly appreciated.

Source data:

Destination sheet:

Into the Destination sheet, I want to pull the "Task Start Date" where the Client Name and Customer Name match and where the Source "Task Description" includes "Nursing". The source sheet may contain multiple rows that meet that criteria and I just need the first occurrence.

Thank you in advance!

Jennifer

Kelly Moore

Hey @JSpears

The syntax of your CONTAINS needs slight tweaking

Replace your CONTAINS with this:

CONTAINS("Nursing",@cell)

The rest of your formula will remain the same

Kelly

Scott Orsey

Hi @JSpears , That looks pretty close. CONTAINS() syntax should be:

CONTAINS("Nursing", @Cell)

If that doesn't get it to work, I would try each condition on its own to see if one of them is not finding the match you want.

Be well

Kelly Moore

Hey @JSpears

The syntax of your CONTAINS needs slight tweaking

Replace your CONTAINS with this:

CONTAINS("Nursing",@cell)

The rest of your formula will remain the same

Kelly

Scott Orsey

Hi @JSpears , That looks pretty close. CONTAINS() syntax should be:

CONTAINS("Nursing", @Cell)

If that doesn't get it to work, I would try each condition on its own to see if one of them is not finding the match you want.

Be well