Index and filter to mirror data

Aladdin_Ajaj 

The formula you provided is using the FILTER function to extract data from the Source_Sheet based on two criteria - currency = "usd" and order = "buy". However, the INDEX function is only returning the first column of the filtered data.

To retrieve all the columns of the filtered data, you can modify the formula as follows: 

=FILTER(Source_Sheet[[date]:[notes]],(Source_Sheet[currency]="usd")*(Source_Sheet[order]="buy"))

This will return a filtered array of data that contains all the columns from the Source_Sheet that meet the currency and order criteria.

Alternatively, if you want to select specific columns from the filtered data, you can modify the formula as follows: 

=INDEX(FILTER(Source_Sheet[[date]:[notes]],(Source_Sheet[currency]="usd")*(Source_Sheet[order]="buy")), , {1,2,3,4,6,7,8,16,17})

 Make sure to remove the empty space between the commas inside the curly brackets if you want to retrieve columns 1, 2, 3, 4, 6, 7, 8, 16, and 17 from the filtered data.