Help with filtering rows within index formula

Copper Contributor

Hi all,

I am using the following to show the data in Sheet2! columns with headers (Sheet2!A1:T1) matching A3:N3


I want to adjust this to only show rows for which Sheet2!I2:I5000=B1 (where B1 will be a data validated dropdown of unique values in Sheet2!I2:I5000).

How can I best achieve this?

2 Replies
FILTER() function may easier. Please attach/share a sample file.


As already mentioned, filter function would be most suitable.

But if you want something in this direction, here is a suggestion.