Forum Discussion
Help - Find the 2nd match using Xlookup
Is there a way using XLookup to return the 2nd (or 3rd, or 4th, or whatever) match in the lookup value? I'm also trying to use as few helper columns as I can. Otherwise I'd just use the VLookup funct...
If you wish to list multiple matches FILTER would be a more appropriate function
= FILTER(Orders[[Material]:[Size]], Orders[Order]=Selected)
If you wish to aggregate similar values then that could be a Pivot Table or SUMIFS/COUNTIFS combined with UNIQUE to identify the possibilities.