Is there a way to spill the result of a Index & Match with Multiple criteria?

[xaikus506]

Hello!, I would like to ask if there is a way to spill the results of Index and Match with multiple criteria?

I tried the following without any luck:

=Index(Index(Return Value,Match(1,(Criteria1)*(Criteria2)),))Sequence(Counta(Number of Desired Rows)
Nested Xlookup
=Offset(Index,Match(1,(Criteria1)*(Criteria2),0)),0,0,Counta())
=Index(Match(Criteria1 with Offset)*(Criteria 2))

Your help is appreciated thanks!

 

[xaikus506]

Hi, I found the answer to my question this may not use Index and Match but it solves my question:

How to Use Multiple Lookup Criteria in a XLOOKUP Excel Formula - Accounting Services - Audit, Tax and Consulting | Aronson LLC

Learn how to use multiple lookup criteria in XLOOKUP Excel Formula.

aronsonllc.com

the syntax is =Xlookup(Offset(lookupvalue1&Offset(Lookupvalue2,lookuparray1&lookuparray2,return array)