This can be done also withINDEX and MATCH, but the syntax is more complex.
In the example shown, we want to retrieve all values associated with Q3.
Lookup row
In the example shown, XLOOKUP is also used to lookup a row.
XLOOKUP supports approximate and exact matching, wildcards (* ?)
for partial matches, and lookups in vertical or horizontal ranges….
