I've created an spreadsheet and I'd like to filter the information in the rows using a drop down filter. I've managed to create the drop down menu in A3 but now I'd like to show the information in the other columns (B3, C3, D3). I guess I need a formula and tried some but still no solution. Thank you for your help!

Google Sheet

1 Answer 1


Use filter(), like this:

=iferror( filter(B4:D, A4:A = A3, len(A4:A)) )

The iferror() and len() bits are optional. The len() condition ensures that no row matches when A3 is blank, and the iferror() wrapper hides the error that occurs then.

See filter() and iferror().

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.