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...
excelmee
Would this formula need to be revised to find the nth result when using only one lookup value (F2)? I tried the formula you posted and it didn't work in such a case.
Would this formula need to be revised to find the nth result when using only one lookup value (F2)? I tried the formula you posted and it didn't work in such a case.
LSpurchasing You just need to change F2:F5&H1 to F2&H1.
If you have a single search key better follow the Index + Filter combo.