fill sheet with values if they occure in another sheet

user_16626107 0
Viewed 41

i have 2 sheets:

Sheet 1: Sheet 1

Sheet 2: Sheet 2

I want to create a formular that is able to select only the relevant information from sheet 1 as soon as a new entry (Starting with "New Meter ID) is done and append these new relevant information to sheet 2. Sheet 2 Shows how it should look like.

Here is my pseudocode logic:

IF there is a new Value in "New Meter ID":
   Select "Old Meter ID", "Building ID", "Address", "active", "p_Name", "POD ID" and put it 
   into sheet 2.

Anybody has an idea?

UPDTAE

Here is current sheet. My Problem with the filter function is, that the filtered data doesn't start at the beginning of the sheet. In a sheet with 1000 + rows, this will lead to many empty rows between the filtered data.

See Picture 3 Picture 3

google-query-language google-sheets-formula google-sheets if-statement filter
1 Answers

try:

=FILTER(Sheet1!B2:I; Sheet1!B2:B<>"")

update:

=FILTER({Sheet1!B2:C, Sheet1!E2:E, Sheet1!G2:I}, Sheet1!B2:B<>"")

or:

=FILTER({Sheet1!B2:C\ Sheet1!E2:E\ Sheet1!G2:I}; Sheet1!B2:B<>"")
user_56326290
Related