How can I use INDEX with 2 MATCHes?

Manpreet Singh Manchanda

Hello,

Could someone guide me to use INDEX with Range from another sheet (single column range (date)) with 2 Matches with range from another sheet ( range 1 is Column A and range 2 is Column B)?

Regards,

Manpreet

Paul Newcome

Are you able to provide a screenshot? From the sound of it, you are going to want an INDEX/COLLECT instead.

=INDEX(COLLECT({Date range}, {Column A}, @cell = "column a criteria", {Column B}, @cell = "column b criteria"), 1)

Paul Newcome

Are you able to provide a screenshot? From the sound of it, you are going to want an INDEX/COLLECT instead.

=INDEX(COLLECT({Date range}, {Column A}, @cell = "column a criteria", {Column B}, @cell = "column b criteria"), 1)

Manpreet Singh Manchanda

Paul... You heard the right sound...Thank you.

Paul Newcome

Happy to help. 👍️