Pull a value from sheet with either multiple IFs or IF combined with V look up

Ryan Rooke · 04/13/21

Hi - based on 2 different criteria I am looking to pull a date from a separate sheet. I have these attempts but had no luck -

Any help suggestions much appreciated.

Ryan

Paul Newcome · 04/14/21

You are most likely going to want an INDEX/COLLECT.

=INDEX(COLLECT({Date Column}, {Task Name Column}, @cell = Project@row, {Helper Column}, @cell = [helper parent]@row), 1)

Paul Newcome · 04/14/21

You are most likely going to want an INDEX/COLLECT.

=INDEX(COLLECT({Date Column}, {Task Name Column}, @cell = Project@row, {Helper Column}, @cell = [helper parent]@row), 1)

Ryan Rooke · 04/15/21

Thanks for that Paul. Worked perfectly. Never used this formula before but certainly will going forward.

Paul Newcome · 04/15/21

Happy to help. 👍️

Best Answer