Search data when having multiple conditions

Hayber

I want to bring the data from a reference field to another sheet having two conditions in a row

Hayber

Hello @Purnima Gore_PGPS and @Andrée Starå

I have solved it with the following formula, which searches for the two data in book 1 (one fixed data and another is the date) and brings the information of a 3 data to the book. Making the condition of two data to bring it, IFERROR also allows leaving the cell blank if it does not yet have information.

=IFERROR(INDEX(COLLECT(Referece book1Result; Reference book1 variable1; "consultation"; Reference book1 variable2; Date current book); 1); "")

Greetings and thanks for responding

Purnima Gore_PGPS

I could you add a screen shot or something @Hayber so that we can see what you were wanting to do.

Andrée Starå

Hi @Hayber

I hope you're well and safe!

It sounds like you need a combination of INDEX COLLECT.

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Hayber

Hello @Purnima Gore_PGPS and @Andrée Starå

I have solved it with the following formula, which searches for the two data in book 1 (one fixed data and another is the date) and brings the information of a 3 data to the book. Making the condition of two data to bring it, IFERROR also allows leaving the cell blank if it does not yet have information.

=IFERROR(INDEX(COLLECT(Referece book1Result; Reference book1 variable1; "consultation"; Reference book1 variable2; Date current book); 1); "")

Greetings and thanks for responding

Andrée Starå

@Hayber

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!