Select Where but Excel

Copper Contributor

Hello Friends,


I would like to return values in one column based on certain conditions in a different column (but on a separate sheet).


Does anyone know the best way to do this? I basically want to create a new table from another table with filtered values but make it refreshable.


Help? I might be overthinking this.




2 Replies
best response confirmed by terraficke (Copper Contributor)


If you have Office 2021 or Microsoft 365, you can use the FILTER function 

@Hans Vogelaar I have googled and googled this and somehow never came across this SIMPLE solution. Thank you!