0

I’m just having an issue. I need to IMPORTRANGE two Google sheet tables, but in the main source table is a filter turned on. I need to connect data from column "D" with name RM and categorize it according the column "A" with name Plant and from that column I need only data for "Cold SK".

As you can see, the rows are disordered now (it starts with number 2 and then number 9 etc.). Could someone please help me with how to use IMPORTRANGE function correctly in this case? Is it even possible?

This is how table looks like

Improve this question
2
  • Welcome to Web Applications SE. The screenshot does not show disordered rows; it shows a sheet with filtered / hidden rows because a sheet/range filter is applied on column A. This kind of filter applies to the whole sheet. You could filter the data returned by formula by using functions like FILTER, QUERY or the newer functions based on LAMBDA, like reduce used in the answer to the target question shown in the close as duplicate notice. When asking for help with Google Sheets formulas, describe your spreadsheet, including the spreadsheet locale, include sample data as text, ...
    – Rubén - Volunteer Moderator - ♦
    Commented Sep 7, 2023 at 16:34
  • ... both for the source / reference cells / ranges and the expected output. Include links to relevant questions and explain why they don't meet your needs.
    – Rubén - Volunteer Moderator - ♦
    Commented Sep 7, 2023 at 16:36

0

Reset to default

Browse other questions tagged or ask your own question.