query formula: select all where column in sheet a= column in sheet b

Question

I have 2 sheets in one spreadsheet(assume sheet A and sheet B)

and I want to query all data from sheet B(SELECT *) to sheet A

WHERE value of column E in sheet A = value of column E in sheet B

AND value of column G in sheet A = value of column F in sheet B

what should the formula be?

thanks

Answer 1

You could use a filter formula to achieve that =filter('Sheet A'!A2:Z,'Sheet A'!E2:E = A1)

Enter the formula in cell A2 of Sheet B, and enter your filter term in cell A1