xlookup with arrays

Xlookup will return a single row or column, but not both. Try

Formula:

FILTER(Table1[[valuea]:[valueb]],ISNUMBER(XMATCH(Table1[id],TEXTSPLIT(Table1[@check],,",",1),0)))