Forum Discussion
ASsolarc
Feb 12, 2024Copper Contributor
Help with filtering rows within index formula
Hi all, I am using the following to show the data in Sheet2! columns with headers (Sheet2!A1:T1) matching A3:N3 =IF(INDEX(Sheet2!$A$2:$T$5000,SEQUENCE(ROWS(Sheet2!$A$2:$T$5000)),XMATCH($A$3:$N$...
Harun24HR
Feb 12, 2024Bronze Contributor
FILTER() function may easier. Please attach/share a sample file.