Forum Discussion
mtiblier
Mar 20, 2025Copper Contributor
Return multiple rows with matches
I am trying to compare a variable set of numbers that will be pasted in by a user with two different columns in a table and then outputting the rows that match in either column. I would like to event...
HansVogelaar
Mar 21, 2025MVP
=LET(v, FILTER(A3:J9, ISNUMBER(XMATCH(E3:E9, M2:M6))+ISNUMBER(XMATCH(F3:F9, M2:M6)), ""), IF(v="", "", v))