FILTER

Community Discussions
, ,
1

I have two tables

RATE
From To Rate
Kent Seattle 21$

PAY
From To Pay
Kent Seattle

With Automation I want to populate Pay from Rate column of RATE table I am trying to use below filter query

=FILTER(RATE,"RATE[From]=% AND RATE[To]=%","$[From_DataCell]","$[TO_Data_CELL]")

But its not working Can somebody help me with query to filter row based upon screen input and return value One columns (RATE in this case) and write to PAY table

2

=FILTER(RATE,"RATE[From]=% AND RATE[To]=%","$[From_DataCell]","$[TO_Data_CELL]")[rate]

The filter returns a row, but you need to define a column in the row.