Forum Discussion

Copper Contributor

Feb 12, 2021

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...

excel

SergeiBaklan

Diamond Contributor

Aug 31, 2021

LSpurchasing

If you need nth occurrence, the easiest way is based on what PeterBartholomew1 suggested

MobileTim

Copper Contributor

Jan 20, 2023

Thank you PeterBartholomew1 and SergeiBaklan saved me a ton of time today. Appreciate this community.

SergeiBaklan
Diamond Contributor
Jan 21, 2023
MobileTim , glad to know this forum helped