How to "Filter" content from another sheet?

[Alexandra69]

Hello, I'm using the latest Office and got the following question.

Is there a Way in Excel to show specific content from one sheet in another, similar to the =FILTER function in Google Sheets?

Example:

In sheet 1 column A is a value in each row, this value defines which rows from column B-J are shown in another sheet.

I tried VLOOKUP, though it only shows one cell and only the first row it finds, not all rows that have the same value
in column A.

In the end it should look like this:
Column A Column B-J
Empty No values
A Rows show up in sheet 2
B Rows show up in sheet 3
C Rows show up in sheet 2 and 3

Are there any convenient ways to solve the problem?

[davesexcel]

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.


To add a file to a post

[Alexandra69]

An Example would be:

https://docs.google.com/spreadsheets...gid=2073692773

In sheet B,C,D the Formula in A1, is something like that possible to achieve in Excel?

[JeteMc]

In sheet B,C,D the Formula in A1, is something like that possible to achieve in Excel?

Yes, the following formula will get the same data as the data shown on sheets B, C and D:

Please Login or Register  to view this content.

As to the question asked in post #1 please follow Dave's instructions and upload a sample to clarify what you want.
Let us know if you have any questions.