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