Forum Discussion
Xlookup Return second match.
I have a table like this District Student ABC John JKL Cindy ABC Greg Artesia Denice ABC Aaron Im using this X...
Hi, dshawSLDC
I dont think you can do that with Xlookup. But if you have Xlookup, you also might have Filter?
Filter rows with your conditition. Select wanted row using Index:
=INDEX(FILTER(Tabell1;Tabell1[District]="Abc");G2) Where G2 is the row number you want.
Best Regards
- Geir
This Did the Trick
{=INDEX(Data[Student],SMALL(IF(Data[District]=Invoice!A7,ROW(Data[District])-ROW(INDEX(Data[District],1,1))+1),2))}
Now I just Need to find away to stop when it reaches the last row.
